How to hide columns?

[Jvan]

I only want to show the firt 10 columns, so I need to hide the rest of them.

[wp]

When you want to restrict the number of rows and column usable in the WorksheetGrid you must set the property AutoExpand to [aeDefault] -- then the WorksheetGrid behaves like TStringGrid, i.e. you define the extent of the grid by setting its ColCount and RowCount properties. You cannot navigate beyond these limits, and you only can access cells within these limits. Adding aeData to the set automatically expands the grid when cells are written outside, and adding aeNavigate exands the grid when the user navigates with the arrow keys beyond the limits.

Please read https://wiki.lazarus.freepascal.org/TsWorksheetGrid#New_grid_properties