Pivot Table - Drill down colors hard to read

Pivot Table - Drill down colors hard to read

Post by WyoCracke » Sat, 01 Nov 2003 01:43:00


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
 
 
 

Pivot Table - Drill down colors hard to read

Post by Debra Dalg » Sat, 01 Nov 2003 13:20:34

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.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.yqcomputer.com/