Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, and 2013. 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: Selecting a Paper Source.
by Allen Wyatt
(last updated June 6, 2015)
Excel supports any printer supported by Windows. This is because Excel uses the features offered by Windows to print documents. Many of the features associated with formatting your document and printing are related to the type of printer you have installed and selected. For instance, some laser printers have different bins for different paper. Windows (and thus Excel) can instruct the printer to select paper from any of the available paper bins.
If you are using a printer that supports multiple paper sources, you may want to change the paper source used for your document. (For instance, you may have a paper tray that contains legal-size paper and you want to print on it.) The first step is to inform Excel of the printer you are using:
If, in step 5, you don't see different options for paper sources, then your printer (or printer driver) does not support multiple sources.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (10921) applies to Microsoft Excel 2007, 2010, and 2013. You can find a version of this tip for the older menu interface of Excel here: Selecting a Paper Source.
Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA today!
If there are error values in a worksheet, you may not want those error values to appear on a printout. Excel actually allows ...Discover More
If you want to print just the contents of a number of rows and columns, it can be challenging to get the output you want. ...Discover More
Ever printed out a worksheet only to find that you have text only at the left side of each page? You can use more of each ...Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.