If you are working with a large spreadsheet, you may want to only print a portion of the total worksheet. Why print out 1200 rows of data when you only need 25? Follow these steps to print part of a spreadsheet:
1. Select the portion of the spreadsheet that you wish to print.
2. Click Format.
3. Mouseover Print Ranges and select Define.
Now when you print the document, only the selected portion of the spreadsheet will print.
To clear the print area and return to printing the entire spreadsheet:
1. Click Format.
2. Mouseover Print Ranges and select Remove