Excel question: what must I do to repeat a row in every page?

J

jstluv2smile

What must I do in order to repeat a row on each page of my spreadsheet?
Can you help? Thanks!
 
N

Nick Hodge

If you are looking to enter stuff in the same cells on all sheets then click
on the first, hold the shift key down and click on the last and enter the
data you want. This will have highlighted all the sheets between the clicks
and [Group] will appear in the workbook header.

You can also use the Ctrl key rather than shift to highlight non-contiguous
sheets.

You can either click on a non-selected sheet tab to -un-group them or
right-click on a selected one and select 'un-group'

Hope that's what you meant

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]
 
N

Niek Otten

If you mean print a heading row on each page:

File>Page Setup, Sheet tab, Rows to repeat at top, click you row

If you mean on the screen:

Select the row just under the one you want to keep, Window> Freeze Panes

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| What must I do in order to repeat a row on each page of my spreadsheet?
| Can you help? Thanks!
 
J

jstluv2smile

Hello, Nick!
How nice of you to respond so quickly. Would your response reply to someone
who wants to copy a column heading so that it can be viewed on top of the
page for each new page? Again, thanks.
 
N

Nick Hodge

I think I mis-understood, 'I'm not sure really what you are trying to do.
Take a look at Niek's answer. If that is right,fine. If not give a little
more detail on what you are trying to do

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]
 
G

Gord Dibben

First, let's establish what you mean by "page"

In Excel it is customary to refer to printed pages as pages and separate
worksheets as sheets or worksheets.

Which are you referring to?

If printed pages, Nick's answer is correct.

If sheets, you would have to copy the top row of sheet1 to sheet2, sheet3, etc.

You can do this easily be selecting sheet1 then right-click on the tab and
"select all sheets".

Enter what you want in sheet1 top row and it will be done to all sheets.

..........................

Another twist....maybe you just want the top row to be visible as you scroll
down in a sheet.

Select A2 and Window>Freeze Panes.


Gord Dibben MS Excel MVP
 
S

Salman

is there any way if we want row repeat on 4 pages out of 6 pages through page
setup ???
 
Top