Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
"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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
"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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
"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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
"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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
"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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use of "&" in Header name ex. "CS&T" comes back CS&[Time]? | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) |