Results 1 to 3 of 3

Thread: How to modify the default paper size in Microsoft Excel

  1. #1
    Join Date
    Oct 2011
    Posts
    97

    How to modify the default paper size in Microsoft 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. #2
    Join Date
    Aug 2011
    Posts
    695

    Re: How to modify the default paper size in Microsoft Excel

    That could be a function of your printer setup. Click on Start >Settings >Printers and Faxes. Select your printer, right-click > properties > advanced > printing 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. File>Save 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 File>New or the Toolbar button File>New or CTRL + n. Do not use File>New...Blank Workbook or you will get the Excel default workbook. NOTE: Existing workbooks are not affected by these settings.

  3. #3
    Join Date
    Aug 2011
    Posts
    566

    Re: How to modify the default paper size in Microsoft Excel

    You can do the same from printer properties of Micrcosoft Excel. I will recommend you to check properly to see in the printer properties. Once the paper size is set you do not need to change it again and again. It saved by default.

Similar Threads

  1. How to modify a Inch to Centimeter in Microsoft Excel
    By Blake's in forum MS Office Support
    Replies: 2
    Last Post: 27-01-2012, 08:01 PM
  2. Modify Backup Copy path of Microsoft Excel
    By Kumar esan in forum MS Office Support
    Replies: 6
    Last Post: 25-01-2012, 06:15 PM
  3. Replies: 2
    Last Post: 21-01-2012, 04:45 PM
  4. Not able to set default paper size to A4 in HP Officejet 8500
    By Hadcourt in forum Hardware Peripherals
    Replies: 7
    Last Post: 11-01-2012, 07:29 PM
  5. Cannot see paper size option for legal size paper
    By Cherokee in forum Operating Systems
    Replies: 4
    Last Post: 22-12-2010, 07:31 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,633,521.85297 seconds with 17 queries