ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Rows to repeat at top... Help... (https://www.excelbanter.com/setting-up-configuration-excel/241170-rows-repeat-top-help.html)

K-Bo

Rows to repeat at top... Help...
 
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

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


All times are GMT +1. The time now is 10:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com