Uttam notes that when he looks at the Page Setup dialog box he can specify a paper size for his worksheet. He wonders if there is a way that he can specify a custom paper size, different from those listed in the Page Size drop-down list.
Unlike Word, which can accept custom page sizes and can bypass the printer driver to force the printer to accept it, Excel gets its list of page sizes from those defined in the printer driver. This is why there is no way to set a custom page size in Excel.
That being said, some printer drivers do allow you to define custom page sizes. Understand, however, that this is not a feature of Excel—it is entirely dependent on the printer driver being used. You can see if your printer driver will allow custom page sizes by displaying the properties dialog box for the printer (normally displayed by clicking Properties in the Print dialog box) and poking around in the various tabs and controls it contains.
In those cases where your printer driver allows you to define custom paper sizes and you are successful in defining one (or more), those paper sizes should appear within Excel without your need to do anything else. (Well, you may need to restart Excel or Windows after you create the custom paper size, but that will also depend on your printer driver and how it interacts with Windows.)
If your printer driver does not allow you to define a custom paper size, the only workaround is to use one of the paper sizes it provides. Pick a size that is larger than the custom size you would like to use, and then adjust the margins within Excel so that the resulting printable area on the page is the same as you would use on your custom paper size.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (9389) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Defining a Custom Paper Size.
Solve Real Business Problems Master business modeling and analysis techniques with Excel and transform data into bottom-line results. This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables. Check out Microsoft Excel 2013 Data Analysis and Business Modeling today!
Don't like the print margins that Excel uses by default? You can change the default by changing the workbook on which ...
Discover MoreIf you ever open a workbook and find that your carefully crafted worksheets no longer print on the number of pages you ...
Discover MoreWhen getting ready to print your worksheet, you may want to take a moment to check what margins Excel will use on the ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2015-05-25 19:34:57
goochi32
For those looking to change the page size for saving to PDF (for some reason the "Save As PDF" option requires a printer driver, unlike Word), follow these instructions:
http://answers.microsoft.com/en-us/windows/forum/windows_7-hardware/custom-paper-size-for-xps-printer/2e62385e-7129-4368-9ae6-fb44dadee29d
The XPS print driver allows you to create a custom page size. Simply set your printer to the XPS Document Writer and then "Save As PDF". You will have your excel document in a custom page size.
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2021 Sharon Parq Associates, Inc.
Comments