ExcelBanter - Pivot table blank cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot table blank cell (https://www.excelbanter.com/excel-discussion-misc-queries/158469-pivot-table-blank-cell.html)

Tufail

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.

Debra Dalgleish

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

Tufail

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

All times are GMT +1. The time now is 07:53 PM.