Pivot table - default font

F

Francesco

Hello,

I just upgraded to Excel 2007, and struggling a bit at the beggining, as
expected.
I am confident it will go better as I use it!

Quick question: with Excel 2003 I set the default font as Tahoma 10.
This applied anytime I created a new excel file, but also everytime I
created a pivot table from a data tab. This seem to not work for Excel 2007.
Are there two different settings for the font, one for new sheets and one
for pivot tables?

Thanks
 
R

Roger Govier

Hi Francesco

As far as I am aware, there is no setting within the PT itself.
However, if you go to Page layout>Themes>Fonts and create a new Theme Fonts
and choose the Heading and body fonts that you want for the Workbook, then
the PT uses the same theme fonts as the source data.

If you set up a workbook in the way that you want, and make it the default
Book template in your XLSTART folder, then you will get what you want each
time you open a new workbook.
 

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

Pivot Table - Changes 5
Pivot Tables 1
How do I save Pivot Table Data 4
Problem inserting calculated pivot fields into Pivot Table (2007) 1
Pivot Table Default Setting 1
Pivot table wizards 2
Group in Multiple Pivot table 1
Pivot tables - memory issues - please help 2

Top