Print A Spreadsheet
Tutorial donated by Wayne Tschirhard
The purpose of this tutorial is to teach basic spreadsheet skills.
Page Preview Toolbar
The Page Preview Toolbar allows you to see what Calc is going to print.
Bring up the Checking worksheet. (Use the at the bottom left of your spreadsheet.)
Click File > Page Preview. (The Page Preview toolbar appears.)
If you look on the left end of the Page Preview Toolbar (the third toolbar), you will see four book icons with arrows. These let
you view each page that would go to the printer.
The Previous Page icon is first book icon.
The Next Page icon is the second book icon.
The First Page icon is the third book icon.
The Last Page icon is the fourth book icon.
Click on the other icons on the Page Preview Toolbar to see their functions.
Click Close Preview.
Headers And Footers
When printed, all pages will have a Header and a Footer on them. The header
shows the name of the sheet. The footer shows the page number. All the
pages have them. Here's how you can turn them off or edit them:
Click Page Format on the toolbar. (The "Page Style: Default" window appears.
Click the Header tab.
You can turn them off by unchecking the Header check box. You can also format the margins and spacing.
To edit the header, click Edit... (The "Header (Page Style: Default)" window appears.)
Headers and Footers are broken into three sections. You can use one of
the auto-format buttons below the three boxes or type your own header.
Click Cancel. (The "Header (Page Style: Default)" window closes.)
Uncheck the Header box. Look through the other tabs.
Click OK. (The "Page Style: Default" window closes.)
The same procedures apply to the footer, so I won't elaborate on that.
The Sheet tab gives you the capability to control the way Calc determines the page
order and what features to print or scale. The remaining tabs are self-explanatory.
Note: Removing the header and footer will change the chart size, so you may
have to resize it.
What if you don't want to print the whole worksheet? I'm glad you asked!
Calc gives you the ability to define print ranges.
Bring up the Checking worksheet.
Select A1:G25. (Click "A1". Drag copy to "G1".)
Click Format > Print Ranges > Define.
Open the Page Preview again.
Now you only have one page. Unfortunately, there is not an equivalent for
charts. The only way you can print a chart only is:
Click File > Print...
Click the Pages radio button on the bottom left.
Type in the page number of the worksheet the chart is on.
Tutorials are improved by input from users. We solicit your constructive
Click here to E-mail your suggestions and comments
Edited by Sue Barron
Print A Spreadsheet 04/27/07
Last modified: 2008-04-30 01:42 UTC