change default paper size in Excel
That could be a function of your printer setup.
Try StartSettingsPrinters and Faxes.
Select your printer, right-clickpropertiesadvancedprinting defaults
Set your printer defaults for paper size.
Note: this is a global setting so all print jobs will be set to A4
If you don't want that, create a template for all new workbooks with that
setting.
Open a new workbook. Customize as you wish.
FileSave As Type: scroll down to Excel Template(*.XLT) and select. Name your
workbook "BOOK"(no quotes). Excel will add the .XLT to save as BOOK.XLT.
Store this workbook in the XLSTART folder usually located at........
C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART
This will be the default workbook for FileNew or the Toolbar button FileNew or
CTRL + n
WARNING................Do not use FileNew...Blank Workbook or you will get the
Excel default workbook.
NOTE: Existing workbooks are not affected by these settings.
Gord Dibben MS Excel MVP
On Tue, 9 Oct 2007 19:48:02 -0700, Bryan
wrote:
The Help is not very helpful when it comes to changing the default paper
size. My work computer is set to letter size which I will never use, I need
A4. I don't have this problem at home. But I don't know how to change it.
The hidden Personal.xls is set to A4, but all new workbooks are not.
|