Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 2nd 04, 12:53 AM
Mansel
 
Posts: n/a
Default 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   Report Post  
Old December 2nd 04, 01:55 AM
Bob Umlas, Excel MVP
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel converts Mapped drive to UNC - How to stop? Fred Links and Linking in Excel 1 January 20th 05 01:24 AM
create space in line chart between points, linked to pivot table Mike -Z- Charts and Charting in Excel 1 December 7th 04 10:39 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 04:56 AM
using the PIVOT TABLE and CHART Big Red Excel Discussion (Misc queries) 1 November 29th 04 09:42 PM
No Smart Tag help: just a blank "MS Excel Help" window - Excel 2003 Ian Ripsher Excel Discussion (Misc queries) 0 November 26th 04 09:43 PM


All times are GMT +1. The time now is 02:04 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017