| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
In excel and a pivot table - how can I stop it displaying (blank).
Hi there, I'm learning to use pivot tables. How can I stop the table listing
(blank) in certain cells? I want to keep the data it relates to but would rather see that cell empty Regards Mansel |
|
#2
|
|||
|
|||
|
In step 3 of the pivot table wizard, you can click the Options button, and in
this dialog there's a checkbox "For Empty Cells, show" and you can fill in something (or leave blank) HTH Bob Umlas Excel MVP "Mansel" wrote: Hi there, I'm learning to use pivot tables. How can I stop the table listing (blank) in certain cells? I want to keep the data it relates to but would rather see that cell empty Regards Mansel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel converts Mapped drive to UNC - How to stop? | Links and Linking in Excel | |||
| create space in line chart between points, linked to pivot table | Charts and Charting in Excel | |||
| pivot table multi line chart | Charts and Charting in Excel | |||
| using the PIVOT TABLE and CHART | Excel Discussion (Misc queries) | |||
| No Smart Tag help: just a blank "MS Excel Help" window - Excel 2003 | Excel Discussion (Misc queries) | |||
Linear Mode
