Hi Tricia,
Page borders apply to the entire worksheet, doesn't make any difference
what cells are selected, unless you ask to print a selected range, which
would be similar to limiting your print area. Have you tried
File, Page Setup, General, Fit to 1 pages wide, the fit to pages high is
and independent setting which you can leave empty.
-
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Tricia" wrote in message ...
I have data that spans several pages and would like a page border on the
printed copy. How can I do this without selecting the range of cells on
every page and outlining with border. My data changes and this is a real
pain to re-do every time.