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?

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?

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?

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?

You're welcome.

Pete

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

simple when you know how..;-)

tks muchly