Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changed Titled bar and now sort doesn't default to "Header Row" | Excel Discussion (Misc queries) | |||
Graphic in Header scaling with pages contents | Excel Discussion (Misc queries) | |||
header or footer | Excel Worksheet Functions | |||
how do I permanetly add custom header to excel header list? | Excel Discussion (Misc queries) | |||
Default header in Excel under page set-up | Excel Discussion (Misc queries) |