Calc: Print Part of a Spreadsheet

Posted March 5, 2007 by Rob Rogers in Windows

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


About Rob Rogers

Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
View more articles by Rob Rogers

The Conversation

Follow the reactions below and share your own thoughts.

Leave a Reply