Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Why does (blank) display on pivot table
I have created a pivot table and a couple of columns that I have used have no
data in them. However those columns are displaying (blank) in the pivot table. I need it to not display anything so that once the pivot is printed the field can be written in. I have deleted all data in those columns, under 'options' I have checked 'For empty cells show...' and erased the field next to it but it still displays in the pivot table as (blank). Your thoughts...thanks JP |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Why does (blank) display on pivot table
The For empty cells show... setting controls cells in the data area.
For row and column headings, you can select a cell that says (Blank), and type a space character on the keyboard. The cell will appear blank. pj wrote: I have created a pivot table and a couple of columns that I have used have no data in them. However those columns are displaying (blank) in the pivot table. I need it to not display anything so that once the pivot is printed the field can be written in. I have deleted all data in those columns, under 'options' I have checked 'For empty cells show...' and erased the field next to it but it still displays in the pivot table as (blank). Your thoughts...thanks JP -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Why does (blank) display on pivot table
Thanks Debra that worked perfectly.
What I need to do now in that same blank column is allow a user to enter a number on the pivot table. I find that when I enter anything in one cell it copies to every cell in that column. Is there a lock somewhere on it or is a pivot table input prohibited? Thanks again - PJ "Debra Dalgleish" wrote: The For empty cells show... setting controls cells in the data area. For row and column headings, you can select a cell that says (Blank), and type a space character on the keyboard. The cell will appear blank. pj wrote: I have created a pivot table and a couple of columns that I have used have no data in them. However those columns are displaying (blank) in the pivot table. I need it to not display anything so that once the pivot is printed the field can be written in. I have deleted all data in those columns, under 'options' I have checked 'For empty cells show...' and erased the field next to it but it still displays in the pivot table as (blank). Your thoughts...thanks JP -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Why does (blank) display on pivot table
All the (blank) items are seen as the same item, so changing one changes
them all. There's no setting you can change to unlock them. Maybe you could enter the numbers in the source data, instead of the pivot table. pj wrote: Thanks Debra that worked perfectly. What I need to do now in that same blank column is allow a user to enter a number on the pivot table. I find that when I enter anything in one cell it copies to every cell in that column. Is there a lock somewhere on it or is a pivot table input prohibited? Thanks again - PJ "Debra Dalgleish" wrote: The For empty cells show... setting controls cells in the data area. For row and column headings, you can select a cell that says (Blank), and type a space character on the keyboard. The cell will appear blank. pj wrote: I have created a pivot table and a couple of columns that I have used have no data in them. However those columns are displaying (blank) in the pivot table. I need it to not display anything so that once the pivot is printed the field can be written in. I have deleted all data in those columns, under 'options' I have checked 'For empty cells show...' and erased the field next to it but it still displays in the pivot table as (blank). Your thoughts...thanks JP -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) | |||
How to get pivot table Time field to appear correctly | Excel Worksheet Functions | |||
How can I show all field data in a pivot table, instead of blank | Excel Discussion (Misc queries) | |||
Pivot table page field switch to (all) if my criteria is not avail | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) |