| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Eliminating empty rows in Pivot table
Problem is that you can't simply filter out some data field because in some
row fields they have values and at some they don't. So what I essentialy need is for those rows to exist when they contain data and to be erased when not containing data.I hope that it+s possible in excel 2007 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Eliminating empty rows in Pivot table
Hi,
Click on the immediate cell to the right of the Grant Total (for columns) cell, and press Auto Filter. This will get the auto filter drop down on the Grand Total column. Now filter out the Blanks. Hope this helps. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "DogEatDog World" wrote in message ... Problem is that you can't simply filter out some data field because in some row fields they have values and at some they don't. So what I essentialy need is for those rows to exist when they contain data and to be erased when not containing data.I hope that it+s possible in excel 2007 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Eliminating empty rows in Pivot table
"Ashish Mathur" wrote: Hi, Click on the immediate cell to the right of the Grant Total (for columns) cell, and press Auto Filter. This will get the auto filter drop down on the Grand Total column. Now filter out the Blanks. Hope this helps. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "DogEatDog World" wrote in message ... Problem is that you can't simply filter out some data field because in some row fields they have values and at some they don't. So what I essentialy need is for those rows to exist when they contain data and to be erased when not containing data.I hope that it+s possible in excel 2007 THANKS A LOT MR MATHUR. IT WORKS |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Eliminating empty rows in Pivot table
You are welcome
-- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "DogEatDog World" wrote in message ... "Ashish Mathur" wrote: Hi, Click on the immediate cell to the right of the Grant Total (for columns) cell, and press Auto Filter. This will get the auto filter drop down on the Grand Total column. Now filter out the Blanks. Hope this helps. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "DogEatDog World" wrote in message ... Problem is that you can't simply filter out some data field because in some row fields they have values and at some they don't. So what I essentialy need is for those rows to exist when they contain data and to be erased when not containing data.I hope that it+s possible in excel 2007 THANKS A LOT MR MATHUR. IT WORKS |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I remove 10,000+ empty rows below my table? | Excel Discussion (Misc queries) | |||
| Hide empty rows in pivot table Excel 2003 | Excel Discussion (Misc queries) | |||
| eliminating empty cells from chart area | Charts and Charting in Excel | |||
| Eliminating Pivot Table Subtotals | Excel Discussion (Misc queries) | |||
| Pivot Tables: How do I show ALL field rows, including empty rows?? | Excel Worksheet Functions | |||
![DogEatDog World[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
