Thread: Pivot Table
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gregzilla Gregzilla is offline
external usenet poster
 
Posts: 4
Default Pivot Table

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".

"Gregzilla" wrote:

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.