"Header" for table/worksheet

[Guest]

how would i go about setting up a number of rows to always print at the top
of a page?

Like i'll have a device number, device description, model number, part name,
quantity vendor, and other items. and i'd like that heading printed on each
page.

how would i go about it, having say rows 1, 2 and 3 being printed on the top
of every page i print?

thanks

 

[Bob Phillips]

Go to File>Page Setup>Sheet and enter $1:$3 in Rows to Repeat box.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Mike
Got to File > Page SetUp > Sheet
and select Rows within the "Print titles / Rows to repeat at top" window.

M

 

[Guest]

file>pagesetup>sheet> select the rows to repeat at top

 

[Guest]

wow.

so many people.

thanks so much.

also, is there a way to have the repeated rows stay "locked" in place on the
normal view. i.e. allow me to scroll down the spreasheet and keep the 3 rows
up top?

 

[Guest]

goto column A in the cell just below where you want the rows to stay and
window>freeze panes