# Printing to a Printer or a File.

The Print dialog includes some options related to printing. More detailed options related to printing are in the Page Setup dialog, detailed in Press the Print to print out the workbook. Press the Preview button to display the Print Preview dialog.

## Print Dialog

Click on the Printer radiobutton and click on Print to send the document to your printer. You can also send the printed document to a postscript file.

You may also select a multiple number of copies, or print a subset of the pages of the document.

If you are not sure which pages you need, click on the preview button to see the layout of the printed document.

If you need to change your page size or scale the output to fit properly onto your page, see the

# Page Setup.

The Page Setup Dialog can be used to configure various options related to printing out a workbook. Click on File Menu Page Setup to activate the Page Setup.

## TIP

Remember that at any time you can click on the Print preview button to see what your document looks like with your selected options. See the

## Page Setup Dialog - Page

### Page Setup Dialog - Page

Select portrait or landscape to suit the best layout for your document.

Change the scale your image to fit it to your page size suitably. The scaling can both enlarge and diminish the size of your printed document.

The Fit to option is not available yet.

## Page Setup Dialog - Margins

### Page Setup Dialog - Margins

Adjust the margins by clicking on the arrow buttons for each margin. You will see the preview pane follow your changes.

You may set the margin to be measured in centimetres, millimetres, points or inches.

## Page Setup Dialog - Headers and Footers

### Print Dialog - Headers and Footers

Click on the option menu to choose from a range of different header and footer styles. Customize the header or footer by choosing the last option on the menu.

### TIP

Double clicking on the header or footer preview will quickly allow you to customize that header or footer.

## Customizing Headers and Footers

### Print Dialog - Customize Header/Footer

Enter what text you would like to appear in the header or footer. There are a number of special opcodes for common options. These are:

&[TAB]

  Name of the workbook.

&[PAGE]

  Page number in the printing.

&[PAGES]

  Total number of pages in the printout.

&[DATE]

  Current date.

&[TIME]

  Current time.

## Page Setup Dialog - Sheet

### Page Setup Dialog - Sheet

You can select rows or columns to be printed on every page of the output. This is commonly used for printing column or row names. To enable this, enter the range of cells to be repeated in Rows to repeat... or Columns to repeat.. field. Instead of entering them manually, you can also select columns or rows to be repeated using the mouse.

### WARNING

Note that the rows and columns must be entered as ranges of cells. That is, if you want to have first row repeated, you must enter `A1:IV1`, not just `1`. Similarly, to have column `A` repeated, you must enter `A1:A65536`. The Gnumeric developers are working on this shortcoming.

Select Grid lines to print the cell grid lines with your document. Unselect the button to hide the grid lines from your print output.

Select Black and white to convert the colours in your document to a greyscale range.

Select Styles with no content to ensure cells with style changes will be printed, even if they are empty. For example, if you have a number of cells with the background color changed but no data in them, you can select this option to ensure they are in the printed output.

# Print Preview.

The Print Preview Dialog is used to display what the printed output will look like. The Print Preview dialog can be used to check whether you have the desired formating and layout before you print out the workbook.

## Print Preview Dialog

## Menu Bar

View

  This menu contains:

  - First Page —Shows the first page in the workbook.

  - Previous Page —Shows the previous page in the workbook.

  - Next Page —Shows the next page in the workbook.

  - Last Page —Shows the last page in the workbook.

  - Zoom in —Zooms the current page in, showing more detail.

  - Zoom out —Zooms the current page out, showing less detail.

## Toolbar

Print

  Prints the current worksheet to a file or a printer.

First

  Show the first page in the workbook.

Back

  Show the previous page in the workbook.

Next

  Show the next page in the workbook.

Last

  Show the last page in the workbook.

Zoom in

  Zooms the current page in, showing greater detail.

Zoom out

  Zooms the current page out, showing less detail.

Fit

  Fits the whole page into the screen space.

Fit Wide

  Fits the whole width of the page into the screen space.

Fit Tall

  Fits the whole height of the page into the screen space.