How to Set Print Area in Excel GA S REGULAR Menu Lifewire Tech for Humans Newsletter! Search Close GO Software & Apps > MS Office
How to Set a Print Area in Excel
Before you print, learn these tricks
By Molly McLaughlin Molly McLaughlin Senior Editor & Content Strategist Molly K. McLaughlin has been a technology editor and writer for over a dozen years. She runs product reviews for Lifewire, overseeing the process from hands-on testing to publishing. lifewire's editorial guidelines Updated on July 11, 2022 Tweet Share Email Tweet Share Email MS Office Excel Word Powerpoint Outlook What to Know
Set print area: Select cells > go to Page Layout tab > Page Setup > Print Area > select Set Print Area.Set multiple: Hold Ctrl while selecting areas > Page Layout > Page Setup > Print Area > select Set Print Area.Add cells to area: Select cells to add > Page Layout > Page Setup > Print Area > Add to Print Area. 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
Open a worksheet and select the cells that you want to be part of the print area. To set more than one print area, hold down the Ctrl key and select the areas you want to print. Each print area gets a separate page. Go to the Page Layout tab. In the Page Setup group, click Print Area and select Set Print Area from the drop-down menu. When you save your workbook, it also retains the print areas. How to Add Cells to an Excel Print Area
Once 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. On your worksheet, select the adjacent cells you want to add to the existing print area. Go to the Page Layout tab of the Ribbon. In the Page Setup section, click Print Area > Add to Print Area. How to Clear a Print Area in Excel
You can also change print areas that you no longer need or created by mistake. Click a cell in a print area that you want to remove. Go to the Page Layout tab. In the Page Setup section, click Print Area > Clear Print Area. View Your Excel Print Areas
You can see your print areas and preview them before printing your spreadsheet. To see your print areas: Go to the View tab. In the Workbook Views section, click Page Break Preview. Click Normal in the Workbook Views section to return to the spreadsheet. When you’re ready to print, click File > Print. To the right of the print options, you can scroll through each printable page in the document. Reasons to Set Print Areas in Excel
If 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. Was this page helpful? Thanks for letting us know! Get the Latest Tech News Delivered Every Day Subscribe Tell us why! Other Not enough details Hard to understand Submit More from Lifewire How to Make a Schedule in Excel How to Password Protect an Excel File How to Create a Report in Excel How to Hide and Unhide Columns, Rows, and Cells in Excel How to Make a Calendar In Excel How to Add Line Numbers to a MS Word Document How to Limit Rows and Columns in an Excel Worksheet How to Merge and Unmerge Cells in Excel How to Count Data in Selected Cells With Excel's COUNTIF Function How to Use the MONTH Formula in Excel Use Office Clipboard to Copy Multiple Items in Excel How to Insert Different Page Orientations in Word 2013 How to Delete a Page in Excel How to Move Around and Between Worksheet Tabs in Excel How to Split Cells in Excel How to Print Labels from Excel Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. Cookies Settings Accept All Cookies