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 <Raspu...@discussions.microsoft.com>
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 <Raspu...@discussions.microsoft.com>
> 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 <(E-Mail Removed)>
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 <Raspu...@discussions.microsoft.com>
>> 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 <Raspu...@discussions.microsoft.com>
wrote:
> mujik! thats the puppy!
>
> simple when you know how..;-)
>
> tks muchly
>
>
>