Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com
Answertopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions
Privacy Policy

  




 

 

OpenOffice Calc 3.x Guide
Previous Page Home Next Page

Headers and footers

Headers and footers are predefined pieces of text that are printed at the top or bottom of a sheet outside of the sheet area. They are set the same way.

Headers and footers are assigned to a page style. You can define more than one page style for a spreadsheet and assign different page styles to different sheets. For more about page styles, see Chapter 10.

Setting a header or a footer

To set a header or footer:

  1. Navigate to the sheet that you want to set the header or footer for. Select Format > Page.
  2. Select the Header (or Footer) tab.
  3. Select the Header on option.
Header dialog

From here you can also set the margins, the spacing, and height for the header or footer. You can check the AutoFit height box to have the height of the header or footer automatically adjust.

Margin

Changing the size of the left or right margin adjusts how far the header or footer is from the side of the page.

Spacing

Spacing affects how far above or below the sheet the header or footer will print. So, if spacing is set to 1.00", then there will be 1 inch between the header or footer and the sheet.

Height

Height affects how big the header or footer will be.

Header or footer appearance

To change the appearance of the header or footer, click More.

Header/Footer Border/Background

From this dialog you can set the background and border of the header or footer. See Chapter 10 (Using Styles in Calc) for more information.

Setting the contents of the header or footer

The header or footer of a Calc spreadsheet has three columns for text. Each column can have different contents.

To set the contents of the header or footer, click the Edit button in the header or footer dialog shown below to display the dialog shown below.

Edit contents of header or footer

Areas

Each area is independent and can have different information in it.

Header

You can select from several preset choices in the Header drop-down list, or specify a custom header using the buttons below. (If you are formatting a footer, the choices are the same.)

Custom header

Click in the area (Left, Center, Right) that you want to customize, then use the buttons to add elements or change text attributes.

Image:TAIcon.png Opens the Text Attributes dialog.

Image:TPIcon.png Inserts the total number of pages.

Image:FNIcon.png Inserts the File Name field.

Image:DAIcon.png Inserts the Date field.

Image:SNIcon.png Inserts the Sheet Name field.

Image:TFIcon.png Inserts the Time field.

Image:PNIcon.png Inserts the current page number.



OpenOffice Calc 3.x Guide
Previous Page Home Next Page

 
 
  Published under the terms of the Creative Commons License Design by Interspire