HEADER ?
I have the first row in my sheet as headers for my colums, when I
print they only show up on the first page. is there anyway to make them show up on the top of every page? Thanks Wally |
Click File Page Setup Sheet tab
Under Print Titles, input* in box for: "Rows to repeat at the top:" : $1:$1 (i.e. for row1) Click OK *Instead of keying-in, you could also just click inside the box, then click outside on any cell in row1, say select B1 This'll also give return "$1:$1" inside the box -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Wally" wrote in message ... I have the first row in my sheet as headers for my colums, when I print they only show up on the first page. is there anyway to make them show up on the top of every page? Thanks Wally |
Thank you
Wally On Sat, 16 Jul 2005 21:08:21 +0800, "Max" wrote: Click File Page Setup Sheet tab Under Print Titles, input* in box for: "Rows to repeat at the top:" : $1:$1 (i.e. for row1) Click OK *Instead of keying-in, you could also just click inside the box, then click outside on any cell in row1, say select B1 This'll also give return "$1:$1" inside the box |
You're welcome !
-- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Wally" wrote in message ... Thank you Wally |
All times are GMT +1. The time now is 10:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com