Today we show you how to print out only specific areas of the document that you need.
hit the Page Layout tab on the Ribbon, then the Print Area button and Set Print Area…
While still under Page Layout tap on Print Titles…
The Page Setup screen opens up and youll want to opt for Sheet tab.
This allows you to include any headers or labels associated with the data.
Now youll be able to preview the area youve selected and can print it out.
you’re free to also select multiple areas of the spreadsheet.
Just select another area and when you select Print Area select Add to Print Area.
Then when you go into Print Preview you’re free to page through the different areas youve selected.
The Print Areas will stay set until you clear them out.
Just punch Print Area then select Clear Print Area.
