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? |
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? |
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? |
All times are GMT +1. The time now is 04:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com