Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing Fozen Panes
Is there a way to print a sheet so that the data in the pane above the pane
break prints with the data further down in the lower pane, so it looks like the screen does after you scroll down? I've tried designating the top part and the lower part as the print area but the 2 parts print on separate pages. Thanks in advance for any help. ed |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing Fozen Panes
Maybe hiding the rows that you don't want printed would be enough.
Be aware that if you have manual pagebreaks in those hidden rows, then you'll want to remove those pagebreaks first. expect_ed wrote: Is there a way to print a sheet so that the data in the pane above the pane break prints with the data further down in the lower pane, so it looks like the screen does after you scroll down? I've tried designating the top part and the lower part as the print area but the 2 parts print on separate pages. Thanks in advance for any help. ed -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing Fozen Panes
Is there a way to print a sheet so that the data in the pane above the
pane break prints with the data further down in the lower pane, so it looks like the screen does after you scroll down? I've tried designating the top part and the lower part as the print area but the 2 parts print on separate pages. If I understand you correctly, you can click File/Page Setup on the Excel menu and set the repeat areas (what you now have frozen) in the indicated fields. Doing this will repeat them on each printed page. Rick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Apear Freeze panes when printing | Excel Discussion (Misc queries) | |||
Freze panes | Excel Worksheet Functions | |||
More Dividers for Excel Viewing Panes / multiple panes per axis. | Excel Discussion (Misc queries) | |||
How do I Hide frozen panes when printing? | Excel Worksheet Functions | |||
Freezing panes | Excel Worksheet Functions |