|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 2nd 05, 11:40 PM
|
|||
|
|||
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 
|
| Ads |
|
#2
July 3rd 05, 12:02 AM
|
|||
|
|||
|
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
July 3rd 05, 02:18 AM
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| updating pivot table to include additional rows | Ellen | Excel Discussion (Misc queries) | 8 | July 15th 08 01:33 PM |
| how to delete/clean out the row list in pivot table | john² | Excel Worksheet Functions | 1 | May 26th 05 04:56 AM |
| Pivot table, dynamic data formula | Excel GuRu | Excel Discussion (Misc queries) | 3 | May 3rd 05 10:45 PM |
| Pivot Table Row Cell (Blank) | Santhosh Mani | Excel Worksheet Functions | 1 | April 11th 05 01:02 PM |
| Removing errors from a Pivot table | Mighty Magpie | Excel Discussion (Misc queries) | 2 | February 3rd 05 03:15 PM |
Linear Mode
