how do i set to only see chosen rows and columns in excel

[Rasput1m]

instead of the sheet running on forever in columns and rows - which can be
more than inconvenient especially in a big spreadsheet - i have recently seen
a worksheet where all i could <<see>> and / or <<select>> was a predetermined
set of rows and columns e.g $A$1:$G$17562

how do i do this?

 

[Pete_UK]

You can't delete those unused rows and columns, but you can hide them.

Click on the identifier at the top of column H to highlight it, then
hold the <shift> key down and press <end> once forllowed by <right
arrow>, then release <shift>. You can now click on Format | Columns |
Hide then OK so that you will only be able to "see" columns A to G.
You can do a similar thing to hide unused rows.

Hope this helps.

Pete

 

[Rasput1m]

mujik! thats the puppy!

simple when you know how..;-)

tks muchly

 

[Gord Dibben]

You can also set the ScrollArea by code so's users cannot wander outside the
range you choose.

If interested see here for code and instructions.

http://tinyurl.com/4jg5vl



Gord Dibben MS Excel MVP

 

[Pete_UK]

You're welcome.

Pete