We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

make top rows repeat header rows in CALC

asked 2020-09-10 17:23:44 +0200

demarantz gravatar image

updated 2020-09-21 23:07:14 +0200

Alex Kemp gravatar image

formatting a spreadsheet for printing, I want the top 2 rows to be locked and repeat on each page as header rows. One can do this in MSExcel.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-09-10 18:20:49 +0200

Lupp gravatar image

updated 2020-09-10 18:32:53 +0200

>Format >Print Ranges >Edit...
You can set the Rows to Repeat and/or Columns to Repeat in hindsight.

If a sheet has more than one print range, title rows and title columns afflict them all the same way..

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-09-10 17:23:44 +0200

Seen: 123 times

Last updated: Sep 10 '20