| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Hiding rows
I have rows that only display data if the dollar amount is greater than 0.
I would like to automatically hide the rows that have no data. Is this possible and if so how? |
|
#2
|
|||
|
|||
|
I find the easiest thing to do is to apply Data|Filter|Autofilter to that range.
Then I can filter to show only the non-blanks. Caconz wrote: I have rows that only display data if the dollar amount is greater than 0. I would like to automatically hide the rows that have no data. Is this possible and if so how? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hiding rows based on choice in a listbox | Excel Discussion (Misc queries) | |||
| Hiding of rows and columns | Excel Discussion (Misc queries) | |||
| HIDING ROWS IN PROTECTED WORKSHEETS | Excel Discussion (Misc queries) | |||
| Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
| Copying Rows when hiding other rows | Excel Worksheet Functions | |||
Linear Mode
