Edit header name to make different on different pages?

English
, , ,
#1

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.

#2

Do you mean Format-Page-Header/Footer?

#3

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.

#4

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.

#6

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.

#5

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.

#7

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

#8

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.