Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
XL2003, how can I set the view to show only the cells with data
In Excel 2003, how can I set the view to show only the cells with data in
them and the rest of the spreadsheet be hidden or just show a blank area with no cells showing? -- S Thomas |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
XL2003, how can I set the view to show only the cells with data
You can hide the rows and columns that you are not using. Imagine you
are using columns A to F - highlight column G by clicking the "G" at the top of the column, then hold the <Shift key down and press <End once followed by <Right-arrow then release <Shift. This will have highlighted all the columns from G to IV, then select Format | Columns | Hide. Do a similar thing for the rows - if you make use of 30 rows, for example, highlight all the rows from 31 to the bottom and hide them. You will have a grey area outside your used range. Hope this helps. Pete S Thomas wrote: In Excel 2003, how can I set the view to show only the cells with data in them and the rest of the spreadsheet be hidden or just show a blank area with no cells showing? -- S Thomas |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
XL2003, how can I set the view to show only the cells with dat
That did the trick. I was already trying to do that but was trying the Ctrl
key instead of the shift key. Thank you! -- S Thomas |
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
XL2003, how can I set the view to show only the cells with dat
You're welcome - thanks for feeding back.
Pete S Thomas wrote: That did the trick. I was already trying to do that but was trying the Ctrl key instead of the shift key. Thank you! -- S Thomas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table blank cells show data deleted months ago! | Excel Discussion (Misc queries) | |||
Setting hover data labels to cells other than source data | Excel Discussion (Misc queries) | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |