I have a worksheet I am trying to print so that it fits all the Columns to the width of the page (margin to margin). In my print settings I have "Fit All Columns on One Page" selected and the scaling is set to "Fit To: 1 pages wide by __ tall".
When I go to print it fits to 1 page tall and does not extend all columns the full width of the page. Please help!
Last edited by lhickerson; 09-11-2014 at 03:16 PM.
Odds are that Excel is seeing some of your "blank columns" as part of your used range. You can test this by hitting CNTRL + "End" and seeing what column it goes out to. If it's greater than your "last column" here's how to rectify.
Select the column just past your last column (i.e Column M). Do CNTRL SHFT + RIGHT ARROW to select all columns to the right. Then Right click and Delete. Save your workbook. Now see if the printing is okay. Did that solve your problem?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
This did not work - and for some reason it is the only Sheet in the workbook this is happening to. Any other suggestions?
I got it to work. I had Columns Repeated in the Print Settings - once I deleted those it worked. Thanks for your quick response.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks