Ask Your Question
1

Edit header name to make different on different pages? [closed]

asked 2017-02-04 09:28:08 +0200

appreciatethehelp gravatar image

updated 2020-10-12 00:18:19 +0200

Alex Kemp gravatar image

Hey guys, simple question: how do I change the header on different pages? I have a document with 2 sheets that I want to come out with the headers named "sheet 1" and "sheet 2" but both pages come out with "sheet 1" instead.

I can't seem to find the option under Edit > Headers & footers

EDIT: To clarify, I have a 5 page document and I want different header text for each page so that I can make the headers go sheet 1 of 5, sheet 2 of 5 sheet 3 of 5 etc. Under format > page > header/footer I have unchecked the "same content left/right" box which has enabled me to make the headers different on left and right pages using Edit > Headers & footers. However, this does not allow me to make a different header for each individual page, which is what I'm after.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-05 01:20:59.415932

Comments

Do you mean Format-Page-Header/Footer?

JohnSUN gravatar imageJohnSUN ( 2017-02-04 09:44:51 +0200 )edit

To clarify, I have a 5 page document and I want different header text for each page so that I can make the headers go sheet 1 of 5, sheet 2 of 5 sheet 3 of 5 etc. Under format > page > header/footer I have unchecked the "same content left/right" box which has enabled me to make the headers different on left and right pages using Edit > Headers & footers. However, this does not allow me to make a different header for each individual page, which is what I'm after.

appreciatethehelp gravatar imageappreciatethehelp ( 2017-02-04 12:07:11 +0200 )edit

3 Answers

Sort by » oldest newest most voted
1

answered 2017-02-04 12:45:50 +0200

ratrace gravatar image

updated 2017-02-05 09:03:04 +0200

To have different header and footer for every sheet of your calc document, you have to insert a different page style, for every sheet. To do that, go to menu Format -> Styles and Formatting (F11). To the top of the window choose the "page styles" icon.

Right click and create a new page style. That new page style will be different from any other page style of other sheets and that's why you can have different header/footer for that sheet.

For every sheet you have you can try the same procedure, so that you will have different header/footer.

edit flag offensive delete link more
1

answered 2017-02-04 12:33:33 +0200

JohnHa gravatar image

If you want to have a different header/footer,text etc you must create a new Page Style with the new design. See the manual for more information.

edit flag offensive delete link more
0

answered 2017-02-05 10:31:11 +0200

Soby gravatar image

you can also edit the header tab

go format | page | header check header on then go to edit and you see three area's where you can set the sheet name; date; time; page when done rename the sheet name with the name of choice

edit flag offensive delete link more

Question Tools

2 followers

Stats

Asked: 2017-02-04 09:28:08 +0200

Seen: 1,898 times

Last updated: Feb 05 '17