View Single Post
  #4   Report Post  
David McRitchie
 
Posts: n/a
Default

Hi Karl,
You have not explained what you want to do.
I suspect that you want the borders to continue down to the bottom
even thought the data may have ended in the top third of the page.

Anything along those lines is going to require extra work on your
part. The following would work, and might mess you up at a later
date.
Turn on Borders for all cells (so you will see them when printed).
Use print preview, and return to the spreadsheet
Look on your spreadsheet around row 50 for a dotted line for a border
Select cell above that line that includes right most data, then make
the selection from that cell to cell A1
File, print area, set print area
check with Print Preview, and if okay
File, print

when finished: file, print area, clear print area

---
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

"Paul B" wrote in message ...
Karl, maybe file, page setup, scaling, adjust to ??? % normal size
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Karl" wrote in message
...
im doing a spreadsheet in excel, im using a XP pentium 4 and im trying to

get
it to print large (full page) but i cant find a way of doing this?

Any help