Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Table Row Cell (Blank)
Dear Sir
In my pivot table under the row Field when there is no data it is showing (Blank). How can I avoid appearing (Blank). I dont want to hide the whole row as there are data in adjacent cells. If I put a space on the cells where there is no data, it will solve my problem. But it is not easy to do all the time. Please help Santhosh Kuwait |
#2
|
|||
|
|||
You can fill the blank cells with space characters or with a formula that makes
the cell look empty. I use ="" I hope that it will be a reminder that I put it in there for a reason! You can fill in the empty cells pretty quickly by: selecting your range edit|goto|special click on Blanks click ok--now only the empty cells are selected type ="" hit ctrl-enter to fill those empty cells. Remember to refresh your pivottable. === Alternatively, you could use format|conditional formatting to hide that (blank) value (white font on white fill???). Santhosh Mani wrote: Dear Sir In my pivot table under the row Field when there is no data it is showing (Blank). How can I avoid appearing (Blank). I dont want to hide the whole row as there are data in adjacent cells. If I put a space on the cells where there is no data, it will solve my problem. But it is not easy to do all the time. Please help Santhosh Kuwait -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
Need Formula to display pivot table source data | Excel Worksheet Functions | |||
Automatically print all page contents in pivot table. | Excel Worksheet Functions | |||
Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
Counting blank cells in Pivot Table | Excel Worksheet Functions |