Do not repeat title lines on the last page.
Lavie_estbelle
Posted messages
2
Status
Member
-
Patrice33740 Posted messages 8400 Registration date Status Member Last intervention -
Patrice33740 Posted messages 8400 Registration date Status Member Last intervention -
Hello,
I have a 17-page Excel document with repeated headings (the top 2 rows). I want to keep the document header on the last page but not the top 2 rows.
I thought that by inserting a section break I could change the page layout options, but nothing seems to work :( It doesn't seem to be like in Word.
Do you have a quick solution for me?
Thank you!
I have a 17-page Excel document with repeated headings (the top 2 rows). I want to keep the document header on the last page but not the top 2 rows.
I thought that by inserting a section break I could change the page layout options, but nothing seems to work :( It doesn't seem to be like in Word.
Do you have a quick solution for me?
Thank you!
1 answer
-
Hello,
There is no section break in Excel, it's a spreadsheet, not a word processor.
If you choose to repeat the first 2 rows when printing, it applies to all pages.
I don't see any simple solution to your problem.
If your table is finished and the last page serves a different purpose, use another sheet and select both sheets to print.
Best regards
Patrice
No one can hold all knowledge, that's why we share it.
