Print a Calculation
You can use the toolbar print option to specify the appearance of return sheets and layouts you print, including cover pages, notes, and any links.
The documents that you send to print are created as PDF files that you can send to a physical printer if you want. When your print is available it will be available on the Print screen ( on the main menu bar.)
To print a calculation:
- Open the calculation you want to print.
- Select an option using the Print icon
on the toolbar. You can select the small black triangle to show a menu of additional options.
- If you select the Print icon directly, the Print calculation page opens and provides options to set up your print details.
- If you select the triangle next to the icon, a menu of additional options appears. You can use the options to specify print layout options such as paper size or orientation, or add and remove page breaks.
noteIf you make any formatting changes, be sure to select the Save icon on the toolbar ribbon before closing the calculation. - After you change print options, selectCalculations, thenPrintsto download the file.noteFiles generated for print use the following naming conventions:
- The calculation name.
- The selected sheet. This corresponds to the option you selected in theSheetsdropdown on the Print calculation page.
- The print type. This corresponds to the option you selected in thePrint Typedropdown on the Print calculation page.
- The date and time the file was generated for print.
Calculation Print Layout Options
When you select the Print icon on the toolbar from an open calculation, a page appears that lets you configure details about the print.
- Use theSheetsdropdown to specify the sheets to print, such as the current sheet only or sheets that you specify.
- Use thePrint Typedropdown to indicate the status of selected sheets, such as Draft, Review, or Final.
- Use thePrint Styledropdown list to select a pre-defined print style.
- In the main panel, use the+and-indicators to expand and collapse the list of documents. Check the checkboxes to indicate the sheets you want to print.
- Select the checkboxes in theOptionssection as appropriate to configure additional options.OptionDetailsShow Data Entry CellsIdentifies data entry cells on a printed sheet with a grey shaded background.Forms without BackgroundSelect this option when using pre-printed stationary; only the values in a form are printed.Enable Debug PrintUse this option to enable debug mode to help troubleshoot problems with electronic filing.
- In theNotes and Query Print Optionssection, check the boxes to indicate the information from notes and queries you want to include in the print.noteNotes are limited to 715 characters when printed. Any characters in a note beyond this limit are not included in the printed version of the calculation.
Page Setup options
Use the Page Setup dialog to configure options for the appearance of the printed calculation.
- In theSheetssection, check the checkboxes for the sheets you want to configure.
- ThePrint Titlessection shows the spreadsheets rows and columns that will repeated on each page.
- Use the settings in theOrientation,Paper Size, andScalingboxes to define how to fit the calculation to the printable PDF page.
- In theOptionssection, check the checkboxes next to any additional elements you want to include.
- Select thePrintbutton. When your print is available it will appear on the Print screen (Calculations>Printson the main menu bar.)
Page Setup
You can modify the page setup for one or more sheets at the same time and save the settings for future sessions. To open the
Page Setup
options, select Print
from the calculation workbook toolbar and select Page Setup
.In the
Page Setup
dialog box, select the sheets to set up, and choose orientation, paper size, and scaling. Page Breaks
You can control manually where new pages start in your printed calculations by adding page breaks. Page breaks are indicated by a thin dotted line and can be added for rows or columns.
note
Some templates have row and column breaks, and these are also incorporated into print files.
Row Page Breaks
- To add a page break at a row, select a cell in the row that will be the first row in of the new page.
- On the toolbar ribbon, select the small arrow beside thePrinticon.
- On the menu that opens, selectInsert row page break. The calculation shows a faint dotted line to indicate the break.
To remove a row page break, select the cell below the break and select the small arrow next to the
Print
icon, then select Remove row page break
from the menu.Column Page Breaks
- To add a page break at a column, select the column that will start the new page.
- On the toolbar ribbon, select the small arrow beside thePrinticon.
- On the menu that opens, selectInsert column page break. The calculation shows a thin dotted line to indicate the break.
Removing Page Breaks
From the open calculation that has the breaks, select the small arrow beside the
Print
icon. From the menu, select Remove row page break
or Remove column page break
as appropriate.