| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formating work area?
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formating work area?
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 "HunterDan" wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formating work area?
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 On Tue, 2 Dec 2008 06:30:06 -0800, HunterDan wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use integration to work out the area under a curve? | Excel Worksheet Functions | |||
| Conditional Formating Doesn't Work! | Excel Discussion (Misc queries) | |||
| How do I keep the selection box in the work area | Excel Discussion (Misc queries) | |||
| Conditional Formating won't work | Excel Worksheet Functions | |||
| How do I clear the formating of the area OUTSIDE my chart on my w. | Excel Discussion (Misc queries) | |||
Linear Mode
