View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default "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