Repeat top rows on page to the right

  • Thread starter Thread starter mjones
  • Start date Start date
M

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