Pivot Table

G

Gregzilla

Can you lock columns in a pivot table?

I do not want a column to disappear when data is selected and no record
exists within one of the columns in the pivot table.
 
G

Gregzilla

Yes, there is. You must click in the field you want to remain constant and
select the field settings option, Layout & Print tab, then check the box
"show items with no data".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table filter list - listing irrelevant subcategorys 1
Pivot table grand total location 1
pivot table data 2
Pivot Table won't Get 'r done 1
Pivot table column limits 2
conditional formula 1
Question on the occupied field of the pivot table in excel spreadsheet 0
Column limit for Pivot Table data source 1

Top