Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing Frozen Cells Automatically on every page
Hi, I have put headings on the first row (and frozen that row). Underneath the headings, are numbers which go on for many rows (about 3 pages). How do I print so that I can get the headings on every page? Thx much! -- gin2000 ------------------------------------------------------------------------ gin2000's Profile: http://www.excelforum.com/member.php...o&userid=34606 View this thread: http://www.excelforum.com/showthread...hreadid=562117 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing Frozen Cells Automatically on every page
File|Page setup|Sheet tab
Rows to repeat at top: 1:1 gin2000 wrote: Hi, I have put headings on the first row (and frozen that row). Underneath the headings, are numbers which go on for many rows (about 3 pages). How do I print so that I can get the headings on every page? Thx much! -- gin2000 ------------------------------------------------------------------------ gin2000's Profile: http://www.excelforum.com/member.php...o&userid=34606 View this thread: http://www.excelforum.com/showthread...hreadid=562117 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing Frozen Cells Automatically on every page
Thank you Dave -- gin2000 ------------------------------------------------------------------------ gin2000's Profile: http://www.excelforum.com/member.php...o&userid=34606 View this thread: http://www.excelforum.com/showthread...hreadid=562117 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
printing cells with borders | Excel Discussion (Misc queries) | |||
Printing a sheet onto 4 pages: page 2 is empty. | Excel Discussion (Misc queries) | |||
Adjust the size of cells automatically | Excel Discussion (Misc queries) | |||
How do I freeze or lock cells to show up on each page without typ. | Excel Discussion (Misc queries) | |||
Protected cells -automatically format to a different color | Excel Discussion (Misc queries) |