0

I have an Excel sheet that I'm trying to format for print. I want to turn the top four rows of the sheet (or quite frankly any four rows, I don't care where they're stored) into the header so that they will appear on the top of every sheet.

In terms of creating a header, Excel seems fairly limited. Is there any method I can use to do this?

Improve this question

1 Answer 1

Reset to default
0

Go to Page Layout, Page Setup, Sheet, then select the rows you want to repeat at the top of every page in the "Rows to repeat at top" box:

enter image description here

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .