Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Supress (blank) in pivottable
I have a pivottable like this.
Area Group Description Budget 1. Strategic iniatives Business Growth Buy product X $1 Buy product Y $5 1. Technology upgrades Convert sys A Programming $1 (blank) $5 Excel is putting in the (blank) text because I don't have anything in the cell in the source table and I don't have anything I want to put in that cell - not even "Other"! Can I supress (blank) somehow? Other than putting a space in those cells? Thanks, Walter -- WAC |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Supress (blank) in pivottable
I could just type over that cell with (blank) in it.
If you have trouble, maybe using Debra Dalgleish's pivottable addin would help--besides, there's lots of other stuff in that addin that you may like: http://www.contextures.com/xlPivotAddIn02.html wacNTN wrote: I have a pivottable like this. Area Group Description Budget 1. Strategic iniatives Business Growth Buy product X $1 Buy product Y $5 1. Technology upgrades Convert sys A Programming $1 (blank) $5 Excel is putting in the (blank) text because I don't have anything in the cell in the source table and I don't have anything I want to put in that cell - not even "Other"! Can I supress (blank) somehow? Other than putting a space in those cells? Thanks, Walter -- WAC -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif to return a blank if sum range is blank | Excel Worksheet Functions | |||
Return Summed Count of Multiple Consecutive Numeric Values | Excel Worksheet Functions | |||
Adding a blank in Data Validation List? | Excel Discussion (Misc queries) | |||
Setting Purely BLANK Cell | Excel Worksheet Functions | |||
Blank Cells in Pivot Tables | Excel Discussion (Misc queries) |