Beebs,

Printing is sometimes a bear. Try this. Hightlight the entire area you
want to print. Go to FILEPRINT AREASET PRINT AREA. Next go to
FILEPAGE SETUPPAGE and on that tab are settings under "scaling";
which can force your printer to print the information from your
spreadsheet a certain size or to a certain number of pages.
You mentioned that your header row wasn't printing and I think after
you do the first part that won't be a problem. But if you have a lot of
information that doesn't fit well on one page and you need multiple
pages and you want that header row to appear on each page, that is done
by selecting the "sheet" tab (last one on Page setup) There you will see
"Rows to repeat at top" If your headers are contained in the first row
type in $1:$1 and this first row will be printed on all pages.
HTH


--
Casey


------------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
View this thread: http://www.excelforum.com/showthread...hreadid=469515