Quick Way to Print Only Certain Rows of an Excel Spreadsheet

There are a lot of layout settings that help you define the page layout for printing — background, margins, etc. The Print area option allows you to select a certain area to be printed.

Simply select only the rows that you want to be printed, click on Page layout -> print area -> set print area and then click on print. Only the selected rows will be printed.

Please note that you have to clear the print area for the rest to be printed. This can be done with the Page layout -> print area -> clear print area option.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

More From DevX