Formating work area?

[HunterDan]

I have created a spreadsheet, but I would only like to be able to see that
area which I am using, and not the other unused cells. How can I set this up
so that all I am seeing is my worksheet?

 

[FSt1]

hi
2 ways.
if your used area is say a1:M50...
highlight all columns from N to IV or whateveryou have. then hide the
columns. do the same for rows. hide row from 51 down.
you could also set the borders of unused cells to white which would appears
to turn all unused cell white.
i like the hide rows and columns best.

Regards
FSt1

 

[Gord Dibben]

You can hide unused rows and columns.

Or you could set the scrollarea by VBA so's you cannot move out of a
particular range.


Gord Dibben MS Excel MVP