Ask Your Question

How can I fix the headers in a spreadsheet so, that they will be printed on each page?

asked 2015-10-16 15:44:39 +0200

KenbeD01 gravatar image

updated 2016-03-17 02:49:18 +0200

Alex Kemp gravatar image

Current version of Libre Office:

Operating system: Windows 8.1, language: Dutch

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-02-20 07:11:47 +0200

If your "headers" are rows to repeat, then you need to define print range and edit it (using Format->Print Ranges->Edit...) to define repeating rows (and columns, if required) there.

edit flag offensive delete link more

answered 2017-02-20 07:04:00 +0200

_dave gravatar image

Hopefully, this is what you want. Click on the following: "Format", then "page...", then "Page Style Default", next click on the "header" tab, then finally click on the "edit" button. From here you will be able to set your "headers" for all pages. This based on version

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-10-16 15:44:39 +0200

Seen: 132 times

Last updated: Feb 20 '17