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 |
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 |
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 |
All times are GMT +1. The time now is 05:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com