Limit the sheet size

[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

[tcebob]

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

rs

[Earl Kiosterud]

rs,

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

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"tcebob" <handle @ gwi.net> wrote in message
news:OOInCOqSFHA.3544@TK2MSFTNGP12.phx.gbl...
> Sorry for the flap. It worked after all. Just one thing: how to get them
> back?
>
> rs
>
>

[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

On Tue, 26 Apr 2005 16:17:53 -0400, "tcebob" <handle @ gwi.net> wrote:

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

[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

On Tue, 26 Apr 2005 17:06:09 -0400, "tcebob" <handle @ gwi.net> wrote:

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

[tcebob]

Thank you, Earl & Gord.

rs

"tcebob" <handle @ gwi.net> wrote in message
news:OOInCOqSFHA.3544@TK2MSFTNGP12.phx.gbl...
: Sorry for the flap. It worked after all. Just one thing: how to get them
: back?
:
: rs
:
:

[bilma]

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

Best way to do this is to use the Protect sheet option on the Review tab. On a new sheet click Protect sheet then untick everything except select unlocked cells. Click OK. Now click Unprotect sheet, then select the whole sheet (top left of sheet, click the triangle). From the Home tab, Font group, dialogue box launcher (little arrow at bottom right of the group) select the protection tab and ensure "Locked" is ticked then click OK. Go back to the Review tab and click on "Protect sheet". Now the whole sheet is totally inaccessible. Click "Unprotect sheet" then select all the cells that you wish to allow access to (if you make a mistake it's easy to rectify it later). Go to the Home tab, Font group, dialogue box launcher, Protection tab and ensure the "Locked" box is unticked then click OK. Finally return to the Review tab and select "Protect sheet". You should now find that you can access and modify only those parts of the sheet which you set as "unlocked". I hope this helps.

[FDibbins]

bilma, thanks for the suggestion, but this thread is almost 10 years old, I doubt anyone is still monitoring it