How to Set a Print Area in Excel: Tips and Tricks

Printing a selected part of an Excel sheet has never been easier with the help of EasyClick Academy. By following the steps outlined below, you will be able to set the print area and print any part of your Excel sheet without a hitch.

To print selected cells of an Excel spreadsheet, first, you need to highlight the area. Then go to the ‘Page Layout’ tab, click on ‘Print Area’ where you select the option ‘Set Print Area’. Now if you go to the ‘View’ tab and click on ‘Page Break Preview’, you’ll see how the selected area is distributed on pages.

You can also change the page orientation. Go to the tab ‘Page Layout’ and set the orientation to ‘Portrait’ or ‘Landscape’ – depends on which suits you better. If we now go to ‘File’ and click on ‘Print’, we see a print preview and it looks exactly as we want it to print.

If you want to include more data to the selected print area, you can do so by adding rows adjacent to the last row of the selected area. The added data will expand the current print area and if the originally selected and the added data are not adjacent, Excel will create a new print area.

Sometimes you might need certain rows or columns to repeat. To solve this little problem, go to the tab ‘Page Layout’ and click on ‘Print Titles’. You’ll see a window where you can specify ‘Rows to repeat at top’ or ‘Columns to repeat at left’.

When we have a look at the print preview, we can see that the column with names shows on both pages, which makes it much easier when it comes to reading the data! Once everything’s been set as needed, just hit ‘Print’ to print out only that part of the data table you need.

If you save the workbook now, the print area you’ve set will be saved, too. So, you can print out the same area anytime you open the document. To clear the print area, click on the ‘Page Layout’ tab, click on ‘Print Area’ and select ‘Clear Print Area’.

By following these simple steps, you will be able to print any part of your Excel sheet without any trouble. If you want to know more about adding a header or a footer in Excel, check out more tutorials by EasyClick Academy.