Limit the sheet size

  • Thread starter Thread starter tcebob
  • Start date Start date
T

tcebob

How can I set the sheet size to, say, 40 cols x 60 rows? Tried setting all
other col's to 0 width but panning still brings me into the uncharted grey
region where they used to be.

Thanks,

rs
 
rs,

Drag from inside the last column header to the right, swiping past all the
hidden columns. Then use Format - Column - Unhide
 
rs

Hiding the unused rows and columns then protecting the sheet is the usual
method.

Setting the scrollarea using VBA is another method.

Note: Setting ScrollArea is good for that session only and only the
activesheet. Has to be reset next time workbook is opened.

Best to place the code into a WorkBook_Open Sub in ThisWorkbook module and
specify which worksheet.

Private Sub WorkBook_Open()
Sheets("YourSheet").ScrollArea = "A1:P60"
End Sub


Gord Dibben Excel MVP
 
rs

If you have set unused rows and columns size to zero, you can CTRL + A(twice
in 2003) to select all.

Click on Format>Column>Width and type in 8.43 for standard width.

Same for row height of 12.


Gord Dibben Excel MVP
 
Thank you, Earl & Gord.

rs

: Sorry for the flap. It worked after all. Just one thing: how to get them
: back?
:
: rs
:
:
 
Back
Top