Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
change default paper size in Excel
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I reset the default paper size to A4 in Excel? | Setting up and Configuration of Excel | |||
Changing the default paper size in Excel (2003) ... | Excel Discussion (Misc queries) | |||
Changing the default paper size in Excel (2003) ... | Excel Discussion (Misc queries) | |||
Default Paper Size | Excel Discussion (Misc queries) | |||
Changing Default paper size | Setting up and Configuration of Excel |