How do I insert a page number in the form of 'Page 1 of N' on each page of a spreadsheet?

From Apache OpenOffice Wiki
< Documentation‎ | FAQ‎ | Calc‎ | Formatting
Jump to: navigation, search


How do I insert a page number in the form of 'Page 1 of N' on each page of a spreadsheet?


Page numbers can be inserted into the header or footer sections of a spreadsheet. These will be visible only in the Page Preview mode and on the print. The page numbers will not be visible on, nor are they related to, the calc sheets themselves. The page numbers reflect the defined print areas of the workbook.

To insert page numbers:

  1. Select Edit - Headers & Footers... from the main menu
  2. Depending on where you want the page number to appear, select either the Header or the Footer tab
  3. Click in the area where you want the page number to be displayed (Left, Center, or Right) to place the cursor inside the box.
  4. Type "Page ", then add one space character.
  5. The available data fields are represented by a row of icons below the input areas,
    Click on the document icon with ONE number sign [ # ] to insert the page number placeholder.
  6. Type " of "
  7. Click on the document icon with TWO number signs [ ## ] to insert the page total placeholder
  8. Click OK

Note:

  • The data fields available in the header and footer settings are the only data fields and formats available in spreadsheets.


Personal tools