Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



I need help to lock pivot table header in Microsoft Excel

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 21-02-2012
Member
 
Join Date: Feb 2012
Posts: 13
I need help to lock pivot table header in Microsoft Excel

I apply word wrap on column headings in my pivot table. This expands the header row to 6 lines high. Then I manually resize the row back to 3 lines high to conserve space. However, now when I alter the filters on the table, the pivot table resizes the header back to 6 lines high. H ow can I lock the header height. I have managed to do this somehow on some older spreadsheets, but even when I try to use the format painter to transfer the settings from sheets that do have a fixed header row height to my new
pivot table row, it still can't keep the row height fixed less than the word wrap wants it to be.

Reply With Quote
  #2  
Old 21-02-2012
Member
 
Join Date: Nov 2010
Posts: 420
Re: I need help to lock pivot table header in Microsoft Excel

Right-click on a cell in the pivot table, and choose Table Options. Remove the check mark from AutoFormat table. Add a check mark to Preserve formatting. Click OK.
Reply With Quote
  #3  
Old 21-02-2012
Member
 
Join Date: Nov 2010
Posts: 502
Re: I need help to lock pivot table header in Microsoft Excel

I was toggling those settings, I should have mentioned. After seeing how word wrap was treated by the pivot table fields I was able to figure out the problem. If you select the row and apply word wrap, the pivot table treats the selection as applying to the field name (like when you have the down arrow in the pivot table header and select). The full answer was to select just part of the pivot table and also outside the pivot table, then the wrap appears to apply just to the cells selected. Then you can manually set the row height and the pivot table allows the manual override to continue when it updates.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "I need help to lock pivot table header in Microsoft Excel"
Thread Thread Starter Forum Replies Last Post
How to view pivot table external data source in Microsoft Excel 200 LuniA MS Office Support 2 23-02-2012 11:09 AM
How to move the total column in Microsoft Excel Pivot Table (Cowherd) MS Office Support 2 15-02-2012 04:55 PM
Is it possible that Pivot Table can list duplicate entries in Microsoft Excel Sachi Trivedi MS Office Support 5 24-01-2012 04:02 PM
How to sort report filter values of Pivot Table in Microsoft Excel Lakshaki MS Office Support 2 24-01-2012 01:07 PM
How to repeat row labels on Pivot Table in Microsoft Excel Thedevotee MS Office Support 2 17-01-2012 01:08 PM


All times are GMT +5.5. The time now is 09:36 AM.