Forum Discussion
Help putting header on Excel spreadsheet
My Excel does not have Dialog Box Launcher in Page Setup. Not sure that's what I want, anyway.
What I need to do is have the first line (with column titles) repeated at the top of subsequent pages.
Thank you,
Lucy Doll
Are you running Excel Online (i.e. in your browser)? If so, there is no way to specify that the first row should be repeated.
In the desktop version of Excel, click Print Titles:
- Desktop. When I open Print Titles and get Page Setup, Sheet tab, I see Rows to repeat at top: - but I don't know what to type in that field. The number of the line I want to repeat? Or the text within the cells on that line? Or ? Thanks!
You can click in the Rows to repeat at top box, then point to the row or rows that you want to repeat.
Or enter for example $1:$1 for the top row, or $1:$3 for the top 3 rows.
