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 |
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