Repeating the same row on each page

  • Thread starter Thread starter Marianne
  • Start date Start date
M

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!
 
Marianne said:
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!
Click to expand...

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
 
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
 
Back
Top