Adding a header and footer

To add a header and/or footer, select the Header & Footer command from the Format menu. The "Header & Footer" dialog appears. To create a header click, on the Header button in the dialog; to create a footer, click on the Footer button.

The "Header & Footer" dialog contains three boxes to set up the header and footer information. You can type any text you like into these boxes. Text in the Left box will start printing at the left margin, text in the Right box will end at the right margin, and text in the Center box will appear in the middle.

Use the Font button to set the font for each individual header or footer area.

You can have Ability insert information automatically. Position the cursor in the box where you want the text to appear and then:

Click on this button...

To...

Using this code...

Page Number

Insert the current page number at print time.

&P

File

Insert the name of the spreadsheet file.

&F

Time

Insert the time the spreadsheet was printed.

&T

Date

Insert the date the spreadsheet was printed.

&D

When you select one of these buttons, Ability inserts a code in the dialog box instead of the actual text (since the text changes depending on the current time and date and the number of pages and name of the spreadsheet).

You can delete the codes (or add them by typing them directly) in the same way as you can edit any other text.

If you want to change the default margin between the top and bottom edges of the paper and the header and footer respectively, then click on the From edge box, delete the default setting and type in the new margin in each case as required. This will change the settings for the current spreadsheet.

If you want to set a new default for all spreadsheets then select Options from the Tools menu. Click on the Headers or Footers button in the "Options" dialog. Change the default From Edge setting as required. Note that this changes the setting for all subsequent spreadsheets but not for existing spreadsheets or the current one if it has already been altered in the Headers & Footers dialog under the Format menu.

The First Page box tells Spreadsheet from which page it should begin printing the headers and footers. The default is 1, which you should replace as required.

If you want to create a footer as well as a header, then click on the Footer button and create the footer in the same way as you created the header, before selecting OK to save the new settings.