Limit the sheet size

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
 
E

Earl Kiosterud

rs,

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

Gord Dibben

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
 
G

Gord Dibben

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
 
T

tcebob

Thank you, Earl & Gord.

rs

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