Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
reaapearing header
I have seen excel sheets where the header does not move when you scroll down
the page and it also reappears on each page when you print rather large tables. How do you do that? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
reaapearing header
use Window | Freeze Panes
So, if you want rows 1 and 2 to repeat, select cell C1 and Window | Freeze Panes You can also lock columns on the left in the same way Regards Trevor "Jenny" wrote in message ... I have seen excel sheets where the header does not move when you scroll down the page and it also reappears on each page when you print rather large tables. How do you do that? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
reaapearing header
.... and for printing, choose File/ Page Setup/ Sheet/ Rows to repeat at top.
-- David Biddulph "Trevor Shuttleworth" wrote in message ... use Window | Freeze Panes So, if you want rows 1 and 2 to repeat, select cell C1 and Window | Freeze Panes You can also lock columns on the left in the same way Regards Trevor "Jenny" wrote in message ... I have seen excel sheets where the header does not move when you scroll down the page and it also reappears on each page when you print rather large tables. How do you do that? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Get Intersection value given column header and row header | Excel Discussion (Misc queries) | |||
Excel-Header-My Company Name won't work in Header (AT&T) & Time | Excel Discussion (Misc queries) | |||
Excel: custom header - is it possible to paste into header? | Excel Worksheet Functions | |||
HEADER ? | Excel Worksheet Functions | |||
how do I permanetly add custom header to excel header list? | Excel Discussion (Misc queries) |