| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically hide rows with no values
I have a pivot table which shows Employees (Column A), all months from 07 -
08 (Column B) and a total of each month of missing receipts (Column C). I have a conditional formating set to highlight column B and C if column C has a value in it. What I'm trying to do now is to have the rows with no values in column C automatically be hidden. Any ideas? Ex: Name Mnth Total Doe, John 07 Jan 07 Feb 1 07 Mar |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically Hide rows with a value of zero | Excel Worksheet Functions | |||
| How do I set up Excel to automatically hide certain rows? | Excel Discussion (Misc queries) | |||
| automatically hide rows with zero value | Excel Worksheet Functions | |||
| Hide rows automatically | Excel Discussion (Misc queries) | |||
| How do I automatically hide rows | Excel Discussion (Misc queries) | |||
Threaded Mode
