Frequently asked questions - Calc

From The Document Foundation Wiki
< Faq‎ | Calc
Jump to: navigation, search

How to print only part of a sheet

There are three ways to partially print a sheet.

Define a range for printing

The following instructions will let you define the range to print:

  1. Go to the sheet you want.
  2. Click and drag to select the area of the sheet that you want to print.
  3. Right-click to access the contextual menu and choose Add to print range
  4. Repeat these stages for each area of the sheet that you want to print.

Print only part of the spreadsheet (a selection of rows or columns)

  1. Select the ranges or the columns that you want to print.
  2. Go to File ▸ Print.
  3. In the dialogue that appears, check Selected cells.
  4. Click OK.

Note : You can control the dimensions of your selection. If the selected data do not fit the number of pages desired, adjust the dimensions by following the procedure explained in this question for either a percentage or an actual number of pages.

Hide the zones that you do not want to print

To avoid printing certain columns or rows:

  1. Select the columns or rows that you wish to hide.
  2. Right-click on the headers of the columns or rows to display the contextual menu.
  3. Choose Hide.

The columns or rows disapear and will not be printed. But they still exist! To show them again:

  1. Select a column or row before and a column or row following.
  2. Right-click on the columns or row header to display the contextual menu.
  3. Choose Display.