go to the sheet

Select the area you want printed

Then do
File=printArea=Set PrintArea

--
regards,
Tom Ogilvy

"Bigredno8" wrote
in message ...

When trying to print a spreadsheet,I set the Page Break Preview lines to
one page,then I click on the print preview and the spreadsheet is only
2/3 of the page,I want to be able to spread it out along the entire
sheet,but cant figure out how,any suggestions
Thanks
Steve


--
Bigredno8
------------------------------------------------------------------------
Bigredno8's Profile:
http://www.excelforum.com/member.php...o&userid=17162
View this thread: http://www.excelforum.com/showthread...hreadid=531204