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? |
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 |
All times are GMT +1. The time now is 02:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com