"Header" for table/worksheet
 

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

"Header" for table/worksheet
 

Go to FilePage SetupSheet 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" wrote in message
...
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

"Header" for table/worksheet
 

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

M

"Mike" wrote:

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

"Header" for table/worksheet
 

filepagesetupsheet select the rows to repeat at top

"Mike" wrote:

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

"Header" for table/worksheet
 

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?

"bj" wrote:

filepagesetupsheet select the rows to repeat at top

"Mike" wrote:

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

"Header" for table/worksheet
 

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

"Mike" wrote:

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?

"bj" wrote:

filepagesetupsheet select the rows to repeat at top

"Mike" wrote:

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