| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
removing the word (blank) from pivot table cells
I generated a pivot table in an excel spreadsheet.
Is there any way to instruct excel not to show the word (blank) in blank cells? Thanks |
|
#2
|
|||
|
|||
|
Select the cell that contains (blank), and type a space character.
Or, if you don't want to include the data for blanks, click the dropdown arrow on the field heading, and remove the check mark from (blank). wrote: I generated a pivot table in an excel spreadsheet. Is there any way to instruct excel not to show the word (blank) in blank cells? Thanks -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#3
|
|||
|
|||
|
You may even want to get Debra Dalgleish's addin.
http://www.contextures.com/xlPivotAddIn.html Features described he http://www.contextures.com/xlPivotAddIn02.html wrote: I generated a pivot table in an excel spreadsheet. Is there any way to instruct excel not to show the word (blank) in blank cells? Thanks -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
| how to delete/clean out the row list in pivot table | Excel Worksheet Functions | |||
| Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
| Pivot Table Row Cell (Blank) | Excel Worksheet Functions | |||
| Removing errors from a Pivot table | Excel Discussion (Misc queries) | |||
Linear Mode
