Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 211
Default Pivot tables shows "blank"

Hello one of my columns in the pivot table shows "blank" as the result.
I do not want the word blank I want a nothing on the cell. How isthis done?
thanks
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Pivot tables shows "blank"

You could just type over that cell with (blank) in it. (Use a single space???)

If you have trouble, maybe using Debra Dalgleish's pivottable addin would
help--besides, there's lots of other stuff in that addin that you may like:

http://www.contextures.com/xlPivotAddIn02.html

Marilyn wrote:

Hello one of my columns in the pivot table shows "blank" as the result.
I do not want the word blank I want a nothing on the cell. How isthis done?
thanks


--

Dave Peterson
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 Tables - "(blank)" in rows and cells Peterp Excel Discussion (Misc queries) 0 December 20th 06 09:37 AM
When I type "13" the spreadsheet shows "14." Possibilities? Absolutely Stumped Excel Discussion (Misc queries) 7 May 30th 06 10:19 PM
Pivot Tables - How can I "reset" the selections in "Row Field"? shadestreet Excel Discussion (Misc queries) 3 April 24th 06 06:29 PM
In Excel a cell formatted "currency" shows "######" help! llveda Excel Worksheet Functions 2 April 7th 06 09:39 PM
How do I disable "Get Pivot Data" when working from pivot tables? Frustrated excel 2003 user Excel Worksheet Functions 2 November 29th 05 12:00 AM


All times are GMT +1. The time now is 10:29 PM.

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

About Us

"It's about Microsoft Excel"