Forum Discussion
LDinNC
Feb 22, 2024Copper Contributor
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 pag...
LDinNC
Feb 22, 2024Copper Contributor
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!
HansVogelaar
Feb 22, 2024MVP
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.