Pivot Table - Drill down colors hard to read

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
 
D

Debra Dalgleish

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Pivot table drill down sort 0
Pivot table drill down data 2
pivot table missing rows? 0
Pivot Chart Drill-Down 1
Excel 2007 pivot table using analysis services cube as data source 0
Drill down pivot table data via VBA macro 6
VBA - (re-) Set a Table Style 2

Top