Now you can print any area of any spreadsheet that you want without wasting paper. To remove your print area, follow steps one through three again but select Clear Print Area instead of Set Print Area.
You should only see your print area displayed in the preview. It seems like an unusual step, but bear with us.ĥ. Now save, close, and reopen your Excel sheet. Go to the Page Layout tab and find the Page Setup group. Select the cells that you want to include in your print area.Ģ. Just imagine that you need to print a select list of contacts to distribute in a meeting.ġ. You can use a document of your own or take a few minutes to copy down ours. Ready to get started? How to set a print area in Excelįor our example, we’ll be using a sample contact list. It’s a great way to save some paper and make sure that people won’t be distracted by your extra data.
Here is how to set a print area in Excel.Ī print area is exactly what it sounds like - you only print the important section you need. You could print the entire sheet and highlight the important section, but there’s an easier, more environmentally-conscious way. The process isn’t as simple as printing a single page from Microsoft Word, but you’ve no reason to fret. You’ve probably put in hours of time and effort to build your Excel spreadsheet, and now it’s time to print off a small section of it.
