Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Printing "Freeze Panes"
Is it possible to print my document so that the same (heading) row is at the
top of each new page? Something like what is achieved using the "freeze panes" option, but on the hard copy. I can't just use the header to achieve my intended result. thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Printing "Freeze Panes"
select FILE on the menu and PAGE SETUP, on the sheet tab, select the rows to
repeat at top. hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "sh2195" escreveu: Is it possible to print my document so that the same (heading) row is at the top of each new page? Something like what is achieved using the "freeze panes" option, but on the hard copy. I can't just use the header to achieve my intended result. thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Printing "Freeze Panes"
Yes, you can. Go to ToolsPage SetupSheet then use Rows to repeat at top to
select the heading you want on each new pare. Regards, Ernie Lippert "sh2195" wrote in message ... Is it possible to print my document so that the same (heading) row is at the top of each new page? Something like what is achieved using the "freeze panes" option, but on the hard copy. I can't just use the header to achieve my intended result. thanks! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Yes, you can.
Thank you! This is so helpful. I used this to create a tracking worksheet with a lot of inputs for a calendar.
In some ways it's also like "split view", in that it keeps the same stuff at the start of every page. #split_view #freeze_panes #print_panes #print_freeze On Wednesday, June 25, 2008 2:16 PM sh219 wrote: Is it possible to print my document so that the same (heading) row is at the top of each new page? Something like what is achieved using the "freeze panes" option, but on the hard copy. I can't just use the header to achieve my intended result. thanks! On Wednesday, June 25, 2008 2:28 PM Marcel wrote: select FILE on the menu and PAGE SETUP, on the sheet tab, select the rows to repeat at top. hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "sh2195" escreveu: On Wednesday, June 25, 2008 2:38 PM Ernie Lippert wrote: Yes, you can. Go to ToolsPage SetupSheet then use Rows to repeat at top to select the heading you want on each new pare. Regards, Ernie Lippert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print "freeze panes" on succeeding pages? | Excel Discussion (Misc queries) | |||
I want to lock row 1 in Excel. Why is "Freeze Panes" grayed out? | Excel Discussion (Misc queries) | |||
"freeze panes" in excel '97? | New Users to Excel | |||
Excel loses "Freeze Panes" setting | Excel Discussion (Misc queries) | |||
freeze window creates multiple "views" suffixed with ":n" | Excel Discussion (Misc queries) |