ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot table - default font (https://www.excelbanter.com/excel-discussion-misc-queries/198651-pivot-table-default-font.html)

Francesco

Pivot table - default font
 
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

--
Francesco


Roger Govier[_3_]

Pivot table - default font
 
Hi Francesco

As far as I am aware, there is no setting within the PT itself.
However, if you go to Page layoutThemesFonts 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.

--
Regards
Roger Govier

"Francesco" wrote in message
...
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

--
Francesco



All times are GMT +1. The time now is 10:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com