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

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?

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

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

On Apr 8, 7:09*pm, Rasput1m
wrote:
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?

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

mujik! thats the puppy!

simple when you know how..;-)

tks muchly

"Pete_UK" wrote:

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

On Apr 8, 7:09 pm, Rasput1m
wrote:
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?

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

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

On Tue, 8 Apr 2008 11:37:01 -0700, Rasput1m
wrote:

mujik! thats the puppy!

simple when you know how..;-)

tks muchly

"Pete_UK" wrote:

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

On Apr 8, 7:09 pm, Rasput1m
wrote:
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?

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

You're welcome.

Pete

On Apr 8, 7:37*pm, Rasput1m
wrote:
mujik! thats the puppy!

simple when you know how..;-)

tks muchly