Limiting size of worksheet

[JBL]

I want to set up a worksheet and limit to 25 columns and 200 rows.

I seem to can't find it.

Any suggestions are appreciated.

Jo

 

[Gord Dibben]

Joe

You cannot do away with the unused cells. A worksheet has 256 columns and
65536 rows.

You can hide the rows and columns you don't want to see.
Select them and Format>Hide.

Alternative.........You may want to try setting the Scroll Area.

This setting will not remain after closing the file.
Place a code line in the Workbook open event to set it
each time when you open the workbook.

Right-click on the Excel Logo left of your "File" on menu. Select "View Code"
and paste the following in there. Save the workbook and close/re-open to see
the scrollarea fixed to the range A1:H40

Private Sub Workbook_Open()
Sheets("Sheet1").ScrollArea = "A1:Y200"
End Sub

Adjust to your sheetname and range.

Gord Dibben Excel MVP