How to Set-up Print Area in MS Excel – Guide
To ensure your Excel spreadsheets print correctly, you must define a print area. This is more complex than in Word, where the page size is already set. Defining a print area allows you to select specific areas of the worksheet to be printed on separate pages.
You can add and delete print areas in Sheets, allowing you to customize what is printed on each page. Each print area represents a page, with no limit to the number of areas that can be created. If you need to print everything, all print areas can be removed.
How to define printable area in Excel
A fictitious company’s employee dataset, featuring position, division, city and rental date, can be sorted and printed in various ways. For example, one could generate a list of employees hired before or after a certain date, all in a certain position or from a specific division.
Employees in Atlanta can be easily identified and printed using the print area button, which sorts them by city.
To access the menu strip, click “Page Layout” at the top of the page.
Select the cells you wish to print by clicking the first one and holding down the Shift key on your computer’s keyboard while selecting the other cells.
To set the printable area, click on the “Print Area” button in the top menu, select “Define Print Area,” then press “Enter” or “Return” on your keyboard.
Final note
We hope you found our guide on how to set up a print area in MS Excel helpful. If you have any questions, please don’t hesitate to reach out. Show your support by sharing this article with your friends!
