[Solved] Use a Row as header on all pages?

Discuss the spreadsheet application
Post Reply
Nemesis
Posts: 19
Joined: Wed Jan 08, 2020 5:53 pm

[Solved] Use a Row as header on all pages?

Post by Nemesis »

Hi all!

is it possible to use the (for example) the first row as a header on all pages?

I'm using the first row on the first page as "row description", (for example; serial n/o, username...) and that row is only printed on the first page.

is it possible to set it as a "header" so it appears at the beginning on all pages?
Last edited by Nemesis on Sat Mar 20, 2021 5:19 pm, edited 1 time in total.
Openoffice 4.1.6 on Windows 10
User avatar
MrProgrammer
Moderator
Posts: 4905
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Use a Row as header on all pages?

Post by MrProgrammer »

Nemesis wrote:I'm using the first row on the first page as "row description", (for example; serial n/o, username...) and that row is only printed on the first page. is it possible to set it as a "header" so it appears at the beginning on all pages?
Format → Print Ranges → Edit → Rows to repeat → - user defined - → $1 → OK

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the subject field. Select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel.   The locale for any menus or Calc formulas in my posts is English (USA).
Post Reply