How do I add a footer in LibreOffice Calc?

Documents look nice when you add header and footer in them. If you are making a professional document, writing a book, or any project – headers and footers are a must.

The header contains, in general, the document type which describes the document itself. It might contain chapter names as well if you are writing a book.

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.

Go to the Layout tab and click on the format page button from the Tabbed interface (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.

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.

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.

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

Video

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.

To upload a tree anonymously, click the Upload link in the header of any iTOL page. If you have an iTOL account, and are logged in, the upload link will be replaced with My trees. Click it to open your account page and upload a tree into one of your projects. More information about iTOL accounts and tree management is available below.

Trees should be in plain text files, and in one of supported formats (Newick, Nexus, PhyloXML or Jplace). When uploading Jplace files, make sure that the file extension is .jplace, or the format will not be recognised correctly.

Support for NHX and MrBayes metadata

iTOL can parse various metadata from MrBayes and NHX trees. All metadata values will be extracted, and available for visualization through the 'Bootstrap/metadata' section in the advanced controls tab. In addition, NHX tag name can be used to specify internal node IDs (see examples below).

Support for QIIME 2 QZA trees

iTOL supports direct upload of QZA trees generated by QIIME 2. After the initial upload, these trees can be further annotated using other QZA files. Simply drop a QZA file onto the tree display, or upload it through the Upload annotation files button in the "Datasets" tab of the control panel.

How do I change the footer in LibreOffice?

How do you add add ons to LibreOffice Calc?