Fix my worksheet view

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tia - 15 Oct 2007 18:54 GMT

My current worksheet only uses Rows 1-35 and columns A-H. I want to be able
to grey out or make all other rows or columns disappear so that you don't see
them and when you scan down, you are not suddenly on row 345. I know I've
seen this on other spreadsheets but I'm not sure even where to look in excel.
Thanks!!

Reply to this Message

Don Guillett - 15 Oct 2007 19:09 GMT

Have a look in the vba help index for SCROLLAREA or just hide the
unnecessary rows/columns.

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

> My current worksheet only uses Rows 1-35 and columns A-H. I want to be
> able
[quoted text clipped - 4 lines]
> excel.
> Thanks!!

Reply to this Message

JE McGimpsey - 15 Oct 2007 19:24 GMT

One way:

in the Name box at the left of the Formula Bar, enter 36:65536 (or
35:<the last row> if XL07). Choose Format/Row/Hide.

Similarly, select Columns G:IV (or G:<last column>). Choose
Format/Column/Hide

> My current worksheet only uses Rows 1-35 and columns A-H. I want to be able
> to grey out or make all other rows or columns disappear so that you don't see
> them and when you scan down, you are not suddenly on row 345. I know I've
> seen this on other spreadsheets but I'm not sure even where to look in excel.
> Thanks!!

Reply to this Message

Rate this thread: