How to Set-up Print Area in MS Excel

This tip is about the how to Set-up Print Area in MS Excel. So read this free guide, How to Set-up Print Area in MS Excel step by step. If you have query related to same article you may contact us.

How to Set-up Print Area in MS Excel – Guide

Before printing an Excel spreadsheet, you must set the print area to fit standard paper sizes. It is more difficult than printing from Word, which already has printable areas. If you frequently need to print a specific selection or selections on the worksheet, you can define one or more print areas. So when you print the table, only these areas will be printed, each on a separate page.

You can also add cells to an existing print area and delete one or more print areas if you change your mind. (Or remove all print areas if you need to print everything.) Sheets can have as many print areas as needed; each print area represents a page.

How to define printable area in Excel

For the sake of this example, we use a small dataset about employees of a fictitious company. The dataset includes position, division, city and rental date. You can sort and print data in a variety of ways. You might want a list of just employees hired before or after a certain date, all in a certain position, or employees in a certain division.

We sort employees by city and select only those located in Atlanta to print. Here it is how to do this using the print area button.

Final note

I hope you like the guide How to Set-up Print Area in MS Excel. In case if you have any query regards this article you may ask us. Also, please share your love by sharing this article with your friends.