Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 168
Default Pivot table blank cell

hello,
I am using Pivot Table but have some problam in PT empty cells shown like
(blank) which I really don't need, what shall I do ? I just need them as a
empty !

Thanks in advance.


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,979
Default Pivot table blank cell

Select a cell that shows (blank)
Type a space character, then press Enter
The cells will appear empty

Tufail wrote:
hello,
I am using Pivot Table but have some problam in PT empty cells shown like
(blank) which I really don't need, what shall I do ? I just need them as a
empty !


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 168
Default Pivot table blank cell

Thank you very much Dear ! That's working !



"Debra Dalgleish" wrote:

Select a cell that shows (blank)
Type a space character, then press Enter
The cells will appear empty

Tufail wrote:
hello,
I am using Pivot Table but have some problam in PT empty cells shown like
(blank) which I really don't need, what shall I do ? I just need them as a
empty !


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html


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
pivot table (blank) vs. __ nickname Excel Discussion (Misc queries) 0 September 10th 07 04:50 PM
counting blank cell in pivot table violet Excel Worksheet Functions 3 April 23rd 07 04:24 AM
How to clear the word '(blank)' from a cell in a Pivot Table Rob Conder Excel Discussion (Misc queries) 2 November 3rd 06 07:14 AM
Pivot table creates blank table [email protected] Charts and Charting in Excel 2 October 17th 06 05:21 PM
Pivot Table Row Cell (Blank) Santhosh Mani Excel Worksheet Functions 1 April 11th 05 01:02 PM


All times are GMT +1. The time now is 01:55 PM.

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

About Us

"It's about Microsoft Excel"