Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I remove the (blank) from an excel pivot table?
I am trying to create a pivot table from a liston an excel spreadsheet. Many
of the items on the list will be blank. On the pivot table, the blank items show up as (blank) - I want the cell to be empty! I tried setting the table empty values but that doesn't work...any help would be greatly apprecated... |
#2
|
|||
|
|||
If you click the small black triangle near the top of the Table, a menu will
appear. Just clear the checkbox next to (blank) -- Gary''s Student "MarkfromAZ" wrote: I am trying to create a pivot table from a liston an excel spreadsheet. Many of the items on the list will be blank. On the pivot table, the blank items show up as (blank) - I want the cell to be empty! I tried setting the table empty values but that doesn't work...any help would be greatly apprecated... |
#3
|
|||
|
|||
Debra Dalgleish has a pivottable addin you may like:
http://contextures.com/xlPivotAddIn.html You could just select that cell with (blank) in it and hit the spacebar. You could even go back to the raw data and put ="" in those blank cells. MarkfromAZ wrote: I am trying to create a pivot table from a liston an excel spreadsheet. Many of the items on the list will be blank. On the pivot table, the blank items show up as (blank) - I want the cell to be empty! I tried setting the table empty values but that doesn't work...any help would be greatly apprecated... -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
pivot tables reports - altering display of (blank) cells | Excel Worksheet Functions | |||
removing the word (blank) from pivot table cells | Excel Discussion (Misc queries) | |||
Pivot Table Enhancements/Fixes in Excel 2003 | Excel Discussion (Misc queries) | |||
No Smart Tag help: just a blank "MS Excel Help" window - Excel 2003 | Excel Discussion (Misc queries) |