Skip to content

How to make a header with text and images in Calc from Libre Office?

27 de April de 2021

Even though the tool Calc has the option to add and configure a header in your documents, images cannot be placed on these. But don’t worry, if it is possible to make a header with text and images in Calc from Libre Office.

The Calc header option is a section made up of three sections, that is, right, left and center. Depending on the size of each one, insert words and number of pages. But here you will not be able to place any type of images.

There is a solution for this. This way you will have more freedom to make a header with text and images in Libre Office Calc. Likewise, you can also add the headers of its columns to the data table.

Steps to make a header with text and images in Libre Office Calc

The first thing you need to know to making a header with text and images in Calc of Libre Office is that it is as simple as number titles automatically and it is only to create the logo with the text and the image.

Logo creation

First of all, LibreOffice 32 and 64 bits must be downloaded and installed on Windows, Mac or Linux as the case may be. It should be noted that it is not the same as installing Microsoft Office online in Windows 10.

To do this you must insert an image by clicking on the “Insert”In the menu at the top of the screen. Then select the option “Picture”And then click on“ From start ”. Once you have done this, a file browser window will open. There you must select your logo and click on the button “To open”.

header with images and text in calc

After this, in the spreadsheet click the cell that suits you best and there write the text of your heading. You can edit this text according to your tastes and needs, keep in mind that it must be consistent with the design and colors of your logo.

Set margins and disable header

The second step is to adjust the borders of the page and disable the header. To do this, place in the toolbar the option “Preview page” and click on it. In the preview of the document you will see that the header is seen with the reference of the spreadsheet where it was worked.

To delete that text that refers to the spreadsheet and adjust the upper margins you must click on “Page format” in the preview window. This action will open a concept menu. There go to the section “Header”And then click on the box “Activate header” in order to disable this option.

In section “Footer” you should also disable the footer option. Then go to the section “Page”And there adjust the upper margin of it. When you finish the configuration, press the button “To accept”.

Define rows

The third step is to delimit the number of rows that will be repeated in the header of the entire document. For this, in the menu located at the top of the screen, click on the section “Format”And there choose the option “Print range” followed by “Edit”.

header in LibreOffice Calc

This action will open a conceptual menu, there it locates the section “Rows to repeat”And click on the“Choose”. This will take you to the document, all you have to do there is drag the mouse by pressing the left button to select the header you created earlier.

To finalize this selection, press the button “Enter”. This way you will return to the conceptual menu of “Edit print range” and there click on “To accept«. This will take you back to the document where you can see that you already have your header on all pages.

It really is not a difficult procedure to perform, it is only necessary to know what actions to carry out to make a header with text and images in Libre Office Calc.