Limiting size of worksheet

  • Thread starter Thread starter JBL
  • Start date Start date
J

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
 
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
 
Back
Top