Pivot Table - Drill down colors hard to read

  • Thread starter Thread starter WyoCracker
  • Start date Start date
W

WyoCracker

Is it possible to change the colors of the data when you drill down (double
clicking on a cell) into a pivot table?

For instance, when I do it now, the source data appears with the header row
in a very light blue, and its underlined.

That light blue is just too light for my eyes. I'd like to change it. Is
this something that I inadvertently setup? or is it an Excel default?

Thanks,
Graeme
 
I don't know of any way to change the default settings. However, after
the sheet has been created, you can choose Format>AutoFormat, and choose
a format that you prefer.
 
Back
Top