Ask the Expert

Changing document headers in OpenOffice Calc

How do I make different headers for each individual sheet in OpenOffice Calc?

Requires Free Membership to View

There are some possibilities to work with; all of them might not work depending on your spreadsheet.

  • You can base the header for the document on the sheet name. This is the default. Right-click on the sheet name, choose Rename and the spreadsheet will reflect the current sheet name on every page.

    If the sheet name isn't in the header, choose Format > Page, click the Header tab, click Edit, click in the area where you want the sheet name to show up, then click the Sheet Name icon.

  • You can bypass the Header and Footer tabs and specify that some of the rows or columns in the spreadsheet it self should be repeated at the top of each page.
    1. Choose Format > Print Ranges > Edit.
    2. Click in the Rows to Repeat (or Columns to Repeat field for columns).
    3. Just use your mouse to select the rows to repeat.
    4. Repeat with the other field if you want both columns and rows to repeat.
    5. Click OK.

    You might use IF or other functions to make the contents of the rows you choose to repeat vary for each page. This, of course, would depend a lot on your data and what you want to print on each page.

  • This was first published in November 2006

    There are Comments. Add yours.

    TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

    REGISTER or login:

    Forgot Password?
    By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
    Sort by: OldestNewest

    Forgot Password?

    No problem! Submit your e-mail address below. We'll send you an email containing your password.

    Your password has been sent to: