Chapter 7. Prepare Outputs

Worksheet Setup

Abstract

Change worksheet margins: top, bottom, left, right

Margins refer to the blank areas at the top, bottom and sides of the printed page. The sizes of these margins are set as follows:

Open the document whose margins are to be set.
Format->Page.
Click the Page tab.

Here we are only concerned with the Margins area of this dialogue.

Adjust the margins by typing in the desired measurements into the Left, Right, Top and Bottom windows. Alternatively, clicking on the increase and decrease arrows at the side of the windows allows you to change the settings in increments or decrements of 0.1 cm.
Click OK when you have completed the changes.

	Note
	The settings that you apply in this way will only apply to the current page style. If you have used different page styles in a document, you will need to set each of these independently.

Change worksheet orientation: portrait, landscape

Change paper size

Pages of spreadsheets and other documents can be printed either across the short side of the page (as in the case of this document) or across the long side of the paper. The former is called portrait and the latter landscape.

Landscape orientation is particularly important in the case of spreadsheets as our data often covers many columns.

Generally, we work with A4 size paper. There are, however, many other standard paper sizes. Further, you may form time to time come across non-standard sizes.

To change the worksheet orientation and paper size of the current spreadsheet:

Format->Page.
Click the Page tab.

This displays the same dialogue as in the previous section.
Select portrait or landscape by clicking the appropriate radio button in the Paper format area.
If you are using a standard paper size, click the Format drop down box to select the desired paper size. If you are using a non-standard paper size, adjust the Width and Height entries in the Paper format area.

Adjust page setup to fit worksheet contents on one page, on a specific number of pages

It may be that in creating a spreadsheet we have not been careful is setting our columns widths so that a spreadsheet can fit on a single page. In such a case, Calc can adjust the column widths so that the spreadsheet will fit on a single page.

Select the pages that need to be adjusted.
Format->Page.
Click the Sheet tab.
Click the Fit printout on number of pages radio button
Adjust the number of pages to 1.

If you used a different value, Calc would spread the output across this number of pages. For example, if you entered the value 2, the output would be spread across two pages.
Click OK.

Add, modify text in Headers, Footers in a worksheet

Adding headers and footers

Headers and footers are text and information such as file names and page numbering that are inserted at the top and bottom of each printed page.

Edit->Headers and footers

This brings up the Headers / Footers dialogue.
Click on the Headers tab.

The header is divided into three sections: Left, centre and right.
Enter the appropriate text in each of the sections of the header.
If you wish to format the text, click the text attributes icon:

This will display the text attributes dialogue which will allow you to change the font type and size as well as other attributes such as colour.
Click the Footer tab.

The footer can be created in exactly the same way as the header.
Click OK when done.

Editing headers and footers

If headers and footers have already been defined, Edit->Headers and footers will show the current entries. These can be edited in the usual way.

Insert fields: page numbering information, date, time, file name, worksheet name into Headers, Footers

To the right of the text attributes icon in the Headers / Footers dialogue are a number of other icons. Pressing any of these will insert information such as page numbering, date and file name.

The meaning of these icons is shown in the following table:

File name

Number of pages in worksheet

Sheet name

Date

Current page number

Time


Chapter 6. Charts		Preparation