Page Setup LibreOffice Calc Sheet with Header and Footer


This tutorial explains the steps needed to set up the header and footer in a LibreOffice Calc sheet and customize them.

A well-designed print job does wonder. Isn’t it? But before print, you should make sure how your sheet or a document looks by customizing it.

Designing a page with a header and footer in the LibreOffice Writer document is straightforward because the primary canvas of the Writer itself is similar to an A4 page.

But setting up a page to print in the LibreOffice Calc worksheet is a little complex. Because here, you are dealing with thousands of rows and columns. They are not mainly formatted or displayed in A4 size.

Hence, I will explain how you can easily set up the header and footer in a simple LibreOffice Calc sheet.

Setting up Header & Footer in LibreOffice Calc Sheet

I will use the new Tabbed user interface of LibreOffice for this guide. Because it is easier to use and the options are visible in a convenient way.

If you don’t have the new toolbar enabled, follow the below steps. If it is enabled, skip this step.

Change the default look and feel of LIbreoffice - User Interface
User Interfaces – LibreOffice

Go to the Layout tab and click on the format page button from the Tabbed interface (Figure 1).

Layout Tab
Layout Tab – Figure 1

Firstly, to change the header or footer – choose the appropriate tab. Secondly, to change the contents (such as heading, style, and footer), click on the Edit button for the respective Header or Footer tab.

Header and Footer change1
Header and Footer change – Figure 2

In the Header page style window, you can change what goes into your header. Usually, the entire header section is divided into three parts.

  • Left area
  • Center area
  • Right area

You can type in those areas, as shown in figure 3. You can also choose from the presets available from the Header dropdown below.

Furthermore, to change the style, such as font style, bold, italics etc., you can click several options in the Custom header toolbar, as shown in figure 3.

Change the header style and contents
Change the header style and contents – Figure 3

Similarly, do the same for the footer window.

Once the customization is complete, press Ok.

Now, go to Print > Print Preview and you should see the custom header and footer with your Calc sheet contents, as shown in Figure 4.

Changing Header and Footer in LibreOffice Calc sheet
Changing Header and Footer in LibreOffice Calc sheet

That’s it. You can now hit print to get a nice copy of your spreadsheet.

With the above knowledge, you can now create any custom header and footer for your spreadsheet.

Official help article


If you still need help, here’s a video I prepared for you for the above steps. Have a look.

Closing Notes

I hope this guide helps you to configure the custom header and footer for the LibreOffice Calc program. If you have any comments or having trouble, drop a comment below.

Join our Telegram channel and stay informed on the move.

Notify of

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Newest Most Voted
Inline Feedbacks
View all comments
Susan Sykes

For some strange reason my header and footer are not appearing on page 1. How do I fix that?