View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Rows to repeat at top... Help...

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.

K-Bo wrote:

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
setupsheet 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 setupsheet uncheck "row and column headings"


--

Dave Peterson