 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Printing / September 2006Set print area will not fit on 1 page
I have a table set up and selected as my print area. Print preview shows that it slightly fits over 1 page at 100% adjustment. The page is in Landscape setting. When I try and fit to 1 page wide by 1 page tall it syas it cannot fit as it can not reduce it by more than 10%. It says that the margins do not fit the page size - yet I have put the margins to zero as well. It SHOULD fit one 1 paqe with out any problems. PLEASE ASSIST > I have a table set up and selected as my print area. > Print preview shows that it slightly fits over 1 page at 100% [quoted text clipped - 9 lines] > > PLEASE ASSIST Maybe your table is too big to fit just one page... If would like, you could upload your file to www.rapidshare.de to see if it's possible to reduce something in order to fit the table to one page...  SignatureHope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy Hi Bradley, Check the Used Range with Ctrl+End You may have to reduce your Used Range by deleting rows and columns more information at http://www.mvps.org/dmcritchie/excel/lastcell.htm#makelastcell If that is okay then check your page margins File, Page Setup, margins or better in Print Preview (File, Print Preview) where you can see them using the Margin (tab) Next if it still doesn't quite make it. File, Page Set Up, Page (tab) Fit to _1_ page(s) wide by _1_ pages tall those are two independent settings, You can simply use fit to 1 pages wide and leave the other empty., --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm > > I have a table set up and selected as my print area. > > Print preview shows that it slightly fits over 1 page at 100% [quoted text clipped - 14 lines] > If would like, you could upload your file to www.rapidshare.de to see if > it's possible to reduce something in order to fit the table to one page... |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.