View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default "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