"Header" for table/worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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)
 
Mike
Got to File > Page SetUp > Sheet
and select Rows within the "Print titles / Rows to repeat at top" window.

M
 
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?
 
goto column A in the cell just below where you want the rows to stay and
window>freeze panes
 
Back
Top