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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically hide rows with no values
Mom,
At first glance, you might be able to use Excel's built-in data filter feature. Highligh t the active range of your worksheet, then choose the Data menuFilterAutoFilter. You'll notice that a drop down arrow appears in each column of the first row of your data. Click on the drop down arrow in the first cell of Column C. From the drop down list, select (NonBlanks)...the last choice in the drop down list. All rows of data where the cell in column C is blank will be hidden. Hope this helps. Let me know if this is helpful or not? Best Wishes, Mike "Momof2" wrote: 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 |
Reply |
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) |