Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,480
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Font Size Changes in Pivot Table Upon Refresh Jake[_3_] Excel Discussion (Misc queries) 2 April 4th 23 10:13 AM
pivot table default settings stigarne Setting up and Configuration of Excel 0 April 1st 08 08:21 AM
Pivot Table Default Mike H. Excel Discussion (Misc queries) 1 July 26th 07 10:05 PM
Pivot Table Default - Count to Sum Becky Excel Discussion (Misc queries) 1 June 11th 07 08:51 PM
Pivot Table - Default Settings for Table Options Nacho Excel Discussion (Misc queries) 0 February 25th 05 06:05 PM


All times are GMT +1. The time now is 12:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"