| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to show only filled in cells in Excel
I have a spreadsheet that was sent to me that only contains 2 columns and 6
rows and the rest of the page is not active. I can click and expand them all and when I go to undo it says row height or column width. I have not been able to find the answer or duplicate it myself. I think it would be great to clean up the clutter of my spreadsheets. Thanks for any help. -- Still learning... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I want to show only filled in cells in Excel
Go to row 7 and CTRL + SHIFT + Down Arrow.
FormatRowsHide Select column C and CTRL + SHIFT + Right Arrow. FormatColumnsHide. Gord Dibben MS Excel MVP On Sat, 24 Feb 2007 14:24:08 -0800, Drewjunr wrote: I have a spreadsheet that was sent to me that only contains 2 columns and 6 rows and the rest of the page is not active. I can click and expand them all and when I go to undo it says row height or column width. I have not been able to find the answer or duplicate it myself. I think it would be great to clean up the clutter of my spreadsheets. Thanks for any help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sum color filled cells in Excel with no values or text? | Excel Discussion (Misc queries) | |||
| Is there an Excel formula to sum color filled cells? | Excel Worksheet Functions | |||
| Counting filled cells in excel | Excel Worksheet Functions | |||
| Percentage of filled cells | Excel Worksheet Functions | |||
| show me a filled in timecard example? | Setting up and Configuration of Excel | |||
Linear Mode
