Home > categories > Security & Protection > Safety Gloves > How do I lock cell formats on an Excel 2003 pivot table?

How do I lock cell formats on an Excel 2003 pivot table?

I have some pivot table reports that I do on a regular basis. I use Excel 2003. The problem that I am having is that when someone changes the page or row filters, the format of the column headers changes. For example, if I change the page or row filter to be Wisconsin, the cell formats on the column headers change from being wrap text and a smaller width to being unwrapped and the full width needed for all the letters. Sometimes it also changes the formatted black background with white lettering to a white background with white lettering (kind of hard to read!).I have checked in Excel Help and bought a couple of books but cannot find the solution to this. I have tried unchecking AutoFormat in Pivot Table Options but that changes the stuff that's in the first row.Any help is appreciated!


Us guys aren't as picky of what a girl unlike how SOME girls are picky on what a guy wears. I'll be honest though I wear whatever I want. I don't care what the girl thinks lol. As long as you have confidence and like what you're wearing.
Yes it does. MMA gloves are smaller with less padding so you'll feel the leather much more. You would throw punches faster. You can also grip and grab with the MMA gloves so you can work the clinch much more easier.

Share to: