Rows to repeat at top... Help...

[K-Bo]

Below is an answer to an old post, but i can't acess the field, i've tried
converting the spreadsheet into older versions / etc but it still wont let me
acess the "rows to repeat at top" box. And when it says "Also in page
setup>sheet uncheck "row and column headings" - i can't find that field at
all...



To repeat these on each printed page you would enter $1:$1 in the "rows to
repeat at top" box.

Also in page setup>sheet uncheck "row and column headings"

 

[Dave Peterson]

If you're doing a Print Preview, then there are some fields that are disabled.

If you've grouped sheets, then there are some fields that are disabled.

If you're using xl2003 menus, you can ungroup sheets and use
File|Page setup|Sheet Tab
to change the rows to repeat at top.

And that "row and column headings" checkbox shows up on that same tab in the
xl2003 dialog.