Repeat top rows on page to the right

[mjones]

Hi,

I have a two-page wide spreadsheet and would like to repeat both column
A and the top 4 rows on the second page to the right. Column A works
fine, and the top rows work in a header, but I don't want to use a
header. I want to have formated cells repeat.

Is there anyway to do this in Excel 2003 for Windows?

Thanks and much appreciated if you know.

Michele

 

[Pete_UK]

Just go to File | Page Setup | Sheet (tab), where you can specify "Rows
to repeat at top" and "Cols to repeat at left". From here you can also
do a print preview to see if your settings are as you want them.

Hope this helps.

Pete

 

[mjones]

Hi again,

I know how to set rows to repeat at the top, but my trouble is getting
them to repeat at the top of the page that's to the right side of the
first page, i.e. my second page starts at J1.

I hope this makes more sense.

Thanks Pete,

Michele