Loading
ExcelRibbon.Tips.Net ExcelTips (Ribbon Interface)

Defining a Custom Paper Size

Please Note: This article is written for users of the following Microsoft Excel versions: 2007 and 2010. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Defining a Custom Paper Size.

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 (9390) applies to Microsoft Excel 2007 and 2010. You can find a version of this tip for the older menu interface of Excel here: Defining a Custom Paper Size.

Related Tips:

Change Formatting Based On Your Data! Conditional formatting provides a way for you to adjust the appearance of your data based on the data itself. Discover how to put this amazingly powerful feature to work for you, today. This comprehensive volume is available in two editions. Check out Excel Conditional Formatting today!

 

Comments for this tip:

LT    22 Oct 2013, 15:21
I have the opposite issue. After I upgraded to Office 2010, a document I ahve used for a long time, somehow, has bee saved with a custom page size. No matter what I try I cannot remove the custom page size. All I want to do is print 1 page wide, 2pages tall on 8.5x11, standard paper.
Bipin Lohar    22 Jul 2013, 07:38
This one worked for me. And I am confident will work for everyone.

Go to the Control Panel and click on Printers & Faxes. From the Toolbar,
select File, Server Properties. You can set Custom Page Sizes in the Forms
tab.

source:
http://www.pcreview.co.uk/forums/epson-lx-300-a-t555101.html
Zach    21 Mar 2013, 21:12
Using MS Excel 2010

Some people may view this solution as cumbersome however is great for anyone who would much prefer to use excel oppose to publisher, word, etc.

Create a new Microsoft Word document. Change the paper size to your desired size (3.5"x 2").

Create a new Microsoft Excel spreadsheet. Go to the view tab and select page lay out. Column width & row height will now be visible in inches.

Create a border around the cells (3.5" x 2"). Create your business card ensuring it stays within these parameters. You may have to do some math as you adjust row & column sizes it will be necessary to adjust the other rows and columns. After you've completed your business card, select only the business cards cells. Select the "copy drop down arrow", and choose "copy as picture". Choose "as shown when printed", return to your MS Word document and paste the image.

You'll probably want to remove the border prior to pasting. After pasting you may have to again adjust some cell sizes. If rows/columns are overlapping after pasting - play around with their alignment. If you're proficient in Excel you should have no troubles.
ArtZZnyZZ    08 Jan 2013, 11:12
An easier option, which seems to be 'almost' fully supported within MS Excel 2010 is:

1)Page Setup Tab; 2) Size Option; 3) More paper sizes at bottom of drop down list; 4) Options button (towards bottom right of box); 5) Paper siZe (first line @ 'Basics' tab; 6) User Defined (First option in drop down list under 5) Paper SiZe option); 6) Enter your desired custom paper size; 7) Custom Zize name and Save buttons do NOT work for me; BUT 8) Size settings appear to be saved as document properties upon immediately saving document.

Hope this helps someone . . .
A
Marshall Davis    29 Jun 2012, 14:40
An easy solution is by "printing" to a pdf creator. Most of them have custom paper size settings, which will transfer back to excel. Thanks for sending me down the printer driver path!

Leave your own comment:

*Name:
Email:
  Notify me about new comments ONLY FOR THIS TIP
Notify me about new comments ANYWHERE ON THIS SITE
Hide my email address
*Text:
*What is 3+4? (To prevent automated submissions and spam.)
 
          Commenting Terms
 
 

Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us

 

Advertise with Us

Our Privacy Policy

Our Sites

Tips.Net

Beauty and Style

Cars

Cleaning

Cooking

DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2013)

Gardening

Health

Home Improvement

Money and Finances

Organizing

Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2013)

Our Products

Premium Newsletters

Helpful E-books

Newsletter Archives

 

Excel Products

Word Products

Our Authors

Author Index

Write for Tips.Net

Copyright © 2014 Sharon Parq Associates, Inc.