Repeating the same row on each page

[Marianne]

Can you please tell me how I may go about repeating a top
row (of text) so that it repeats on the top of each page
of a worksheet? Thanks!

 

[dvt]

Can you please tell me how I may go about repeating a top
row (of text) so that it repeats on the top of each page
of a worksheet? Thanks!

Your question is a bit ambiguous, but I'll give it a whirl.

If you're trying to get it to repeat on the top of each page when printing,
File|Page Stup|Sheet Tab|Rows to repeat at top dialog.

If you want the top row(s) to stay on your screen when scrolling around on a
sheet, use the Window|Freeze Panes button. Make the top row(s) visible.
Click the cell in column A just *below* the cells you wish to remain visible
(i.e. select A3 to make rows 1 and 2 always visible). Click Window|Freeze
Pane.

I hope one of these answers your question.

Dave
dvt at psu dot edu

 

[Gord Dibben]

One more interpretation..........

If you are not printing and you do not want rows frozen perhaps you want to
duplicate a row of text on each worksheet as a header(titles).

Right-click on a sheet tab and select "select all sheets". All tabs will turn
white and you will see "Group" up on the Caption bar.

Enter your row 1 text on any sheet and it will be replicated across all
sheets.

DO NOT FORGET to right-click and "Ungroup" sheets before making any other
changes. What is done to one is done to all.

Gord Dibben Excel MVP - XL97 SR2 & XL2002