cmcreynolds
Active Member
- Joined
- May 21, 2015
- Messages
- 295
Hello everyone, again-
I'm using a Power Pivot table to create this report. I don't THINK it matters in regard to my questions below, but I wanted to make sure that I was clear in the kind of pivot table I'm using (Excel 2013). If you'd like me to move it and post it in the Excel Forum, I'll do that, too.
(I have forgotten this) - How can I get the formatting for my column headers to stick? I have nothing filtered and I have the check box filled in "preserve cell formatting on update" in the pivot table's options. I have done this before at my previous job, but I have since forgotten how to keep them from changing every time I refresh the data. I just want to center the column labels and slightly alter the font and size.
I'm using a Power Pivot table to create this report. I don't THINK it matters in regard to my questions below, but I wanted to make sure that I was clear in the kind of pivot table I'm using (Excel 2013). If you'd like me to move it and post it in the Excel Forum, I'll do that, too.
(I have forgotten this) - How can I get the formatting for my column headers to stick? I have nothing filtered and I have the check box filled in "preserve cell formatting on update" in the pivot table's options. I have done this before at my previous job, but I have since forgotten how to keep them from changing every time I refresh the data. I just want to center the column labels and slightly alter the font and size.