Show
What to Know
This article explains how to set the print area for standard paper sizes in Excel 2019, 2016, 2013, 2010, 2007, and Excel for Microsoft 365. Set One or More Excel Print Areas
How to Add Cells to an Excel Print AreaOnce you’ve set a print area, you can add adjacent cells to it, if you made a mistake the first time or input additional data. If you try to add cells that are not adjacent to your print area, Excel creates a new one for those cells.
How to Clear a Print Area in ExcelYou can also change print areas that you no longer need or created by mistake.
View Your Excel Print AreasYou can see your print areas and preview them before printing your spreadsheet. To see your print areas:
Reasons to Set Print Areas in ExcelIf you print out a large spreadsheet without setting print areas, you run the risk of outputting hard to read, unformatted pages. If the sheet is wider or longer than the paper your printer is using, you’ll end up cutting off rows and columns. It won’t look pretty. Setting print areas gives you control over what each page looks like, so it’s easy to read and understand. Thanks for letting us know! Get the Latest Tech News Delivered Every Day Subscribe Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, and Excel in Microsoft 365. 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: Multiple Print Areas on a Single Printed Page.Written by Allen Wyatt (last updated September 15, 2022) Ingrid set up her worksheet just the way she wanted, and then defined two non-contiguous areas on the worksheet as her print area. She first selected A1:C5, then held down the Ctrl key as she selected E3:G5. This selection was then defined as the print area. When Ingrid printed the worksheet, each of the selected ranges (A1:C5 and E3:G5) printed, but they printed on separate sheets of paper. Ingrid was hoping to get them on a single sheet of paper. This happens because Excel automatically prints separate ranges on separate sheets of paper; there is no way to configure Excel to do this printing differently. There are a couple of things you can try as workarounds, however. First, you could print multiple pages per sheet of paper. Follow these steps:
The result, for most printers, is that Excel combines two printed pages on a single sheet of paper. It does this by reducing the size of each of the two pages and printing them in landscape mode on the page. If you cannot find a control that allows you to specify multiple pages per sheet (step 5), it may be that your printer driver doesn't offer this capability. In that case, you won't be able to use this workaround and will have to try the next one. The next solution involves simply creating a "print" worksheet. This sheet can contain references to the original data ranges, combining them on a single worksheet. You can then print the consolidation worksheet, as it will contain only the information you want sent to the printer. A third option involves using the Camera tool. This tool allows you to capture dynamic "pictures" of different areas of your worksheet. The Camera tool is not available, by default, on any of Excel's ribbons. Instead, you need to add it to the Quick Access Toolbar:
Figure 1. The Quick Access Toolbar option in the Excel Options dialog box. You are now ready to use the Camera tool. Follow these steps:
Now you can manipulate the two pictures the same as you would any other graphic—stretch, resize, crop, or move them; whatever. The picture is not really a picture, however, even though it behaves as one. Instead, it is dynamic, meaning that if the contents of the original ranges are changed, then what is shown in the picture changes, as well. You can also print the worksheet containing the camera pictures, and they will appear on a single page. ExcelTips is your source for cost-effective Microsoft Excel training. This tip (8189) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and Excel in Microsoft 365. You can find a version of this tip for the older menu interface of Excel here: Multiple Print Areas on a Single Printed Page. Author BioWith more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. Learn more about Allen... MORE FROM ALLENSuperscripts in Custom Formats When you create custom formats for your data, Excel provides quite a few ways you can make that data look just as you ... Discover More Incomplete and Corrupt Sorting Using the sorting tools, on the toolbar, may result in some unwanted results, such as jumbled data. If this happens to ... Discover More Friendly and Informative Error Handling When creating macros, it is helpful to know what is going on within the macro itself in case an error crops up. Here's ... Discover More How do you select multiple print areas in Excel for Mac?Print selected cells
Select the cells that you want to print. On the File menu, click Print. In the Print box, click Selection in the drop-down list. Click Print.
How do I change print settings in Excel for Mac?With a document open on your Mac, choose File > Print. Click the Presets pop-up menu, then choose your preset. If you don't see the Presets pop-up menu, click Show Details. You see all presets available for that printer.
How do you change the print area on a Mac?Choose File > Page Setup. Click the Settings pop-up menu and choose Page Attributes, then click the Format For pop-up menu and choose Any Printer. This sets the document's scale for all documents you print from this app. Choose File > Print.
How do you print multiple sheets in Excel on a Mac?Print several sheets at once. Select the sheets that you want to print. To select. Do this. Two or more adjacent sheets. Click the tab for the first sheet. ... . On the File menu, click Print.. On the Printer pop-up menu, select the printer that you want.. Next to Print What, click Active Sheets, and then click Print.. |