# Edit header name to make different on different pages?

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 close merge delete

Do you mean Format-Page-Header/Footer?

( 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.

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

Sort by » oldest newest most voted

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.

more

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.

more

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

more