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
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Mail Systems
Eclipse Documentation

How To Guides
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
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.


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


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 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


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


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