{"id":427,"date":"2008-06-09T21:29:56","date_gmt":"2008-06-10T02:29:56","guid":{"rendered":"http:\/\/alsplace.aldenbaker.com\/alsplace\/microsoft\/ms-office\/ms-excel\/427\/excel-make-it-fit-the-page\/"},"modified":"2008-06-09T21:29:56","modified_gmt":"2008-06-10T02:29:56","slug":"excel-make-it-fit-the-page","status":"publish","type":"post","link":"https:\/\/alsplace.info\/?p=427","title":{"rendered":"Excel &#8211; Make It Fit the Page"},"content":{"rendered":"\n<!-- ALL ADSENSE ADS DISABLED -->\n<p align=\"justify\"><font>Do you have an MS Excel worksheet that is sized just barely over the width of a page? If so, if you need to print it on one page only, that extra width is a problem, isn&#39;t it? <\/font><\/p>\n<p align=\"justify\"><font>So, what did you do?<\/font><\/p>\n<p align=\"justify\"><font>Maybe you went back to the worksheet and started adjusting the column widths or maybe you started changing the margins to accommodate your printing needs. <\/font><\/p>\n<p align=\"justify\"><font>Whatever you did, I bet it was a painful process and maybe even impossible. <\/font><\/p>\n<p align=\"justify\"><font>How would you like a method with just one setting that ensures the worksheet will print on exactly the number of pages you require?<\/font><\/p>\n<p align=\"justify\"><font>Interested?<\/font><\/p>\n<p align=\"justify\"><font>Yeah, I thought you might be! <\/font><\/p>\n<p align=\"justify\"><font>If you&#39;re using <strong>older versions of MS Excel<\/strong>, what you&#39;re looking to do is make a quick change in the <strong>Page Setup window<\/strong>. You can get there through the <strong>File <\/strong>menu, <strong>Page Setup<\/strong> choice.<\/font><\/p>\n<ul>\n<li>\n<div align=\"justify\">\n<div align=\"left\"><font>Now, you&#39;re looking for the <strong>Page tab<\/strong>.<\/p>\n<p> <img decoding=\"async\" loading=\"lazy\" src=\"http:\/\/imgsrv.worldstart.com\/mso-images\/fit-to-page-old-excel.gif\" border=\"1\" width=\"400\" height=\"308\" \/><\/p>\n<p> <\/font><\/div>\n<\/p><\/div>\n<\/li>\n<li>\n<div align=\"justify\">\n<div align=\"left\"><font>In the center section (the <strong>Scaling section<\/strong>), you need the &quot;<strong>fit to<\/strong>&quot; choice.<\/p>\n<p> <\/font><\/div>\n<\/p><\/div>\n<\/li>\n<li>\n<div align=\"justify\">\n<div align=\"left\"><font>When you make that selection, you have a couple of settings to change. If you look closely, you&#39;ll notice it actually says &quot;<strong>fit to # page(s) wide by # tall<\/strong>.&quot; The number of pages is what you need to change.<\/p>\n<p> <\/font><\/div>\n<\/p><\/div>\n<div align=\"justify\"><font>If you want the worksheet to print on a single page, just set it to 1 page wide by 1 tall. If the printed data columns are long, you may need 1 page wide by 2 tall. You get the idea. Excel then scales everything down to fit on exactly the number of pages you&#39;ve specified, with no column width changes required!<\/p>\n<p> <\/font><\/div>\n<\/li>\n<li>\n<div align=\"justify\">\n<div align=\"left\"><font>Once you&#39;ve entered your settings, click <strong>OK<\/strong> to save the changes and return to the worksheet. Or, you can choose Print Preview to take a look at your handy work.<br \/> <\/font><\/div>\n<\/p><\/div>\n<\/li>\n<\/ul>\n<p align=\"justify\"><font>For those of you working with <strong>Excel 2007<\/strong>, you&#39;ll need to look in <a href=\"http:\/\/rivervet.com\/\">best price generic propecia<\/a>  a slightly different place. What you need is on the <strong>Page Layout<\/strong> ribbon.<\/font><\/p>\n<ul>\n<li>\n<div align=\"justify\">\n<div align=\"left\"><font>You&#39;re specifically looking for the <strong>Scale to Fit<\/strong> section.<\/p>\n<p> <img decoding=\"async\" loading=\"lazy\" src=\"http:\/\/imgsrv.worldstart.com\/mso-images\/excel-07-scale-to-fit.gif\" border=\"1\" width=\"299\" height=\"271\" \/><\/p>\n<p> <\/font><\/div>\n<\/p><\/div>\n<\/li>\n<li>\n<div align=\"justify\">\n<div align=\"left\"><font>In that section, you&#39;ll find a setting for both <strong>Width<\/strong> and<strong> Height<\/strong>. Each of them have a drop down list where you can set the maximum number of pages for printing in whichever direction you need.<\/p>\n<p> <\/font><\/div>\n<\/p><\/div>\n<\/li>\n<li>\n<div align=\"justify\">\n<div align=\"left\"><font><strong>Make a choice<\/strong> and Excel will then adjust your worksheet immediately. <\/font><\/div>\n<\/p><\/div>\n<\/li>\n<\/ul>\n<p align=\"justify\"><font>I love this one. It certainly beats column width and\/or margin changes anytime! <\/font><\/p>\n<!-- Social Bookmarks BEGIN -->\n<div class=\"social_bookmark\">\n<a title=\"Click me to see the sites.\" href=\"#\" onclick=\"$$('div.d427').each( function(e) { e.visualEffect('slide_down',{duration:2.5}) }); return false;\"><strong><em>Bookmark to:<\/em><\/strong><\/a>\n<br \/>\n<div class=\"d427\" style=\"overflow:hidden\">\n<br \/>\n<br \/>\n<a style=\"font-size:90%;text-align: right; \" title=\"Click me to hide the sites.\" href=\"#\" onclick=\"$$('div.d427').each( function(e) { e.visualEffect('slide_up',{duration:0.5}) }); return false;\">Hide Sites<\/a>\n<\/div>\n<\/div>\n<!-- Social Bookmarks END -->\n<script type=\"text\/javascript\">$$('div.d427').each( function(e) { e.visualEffect('slide_up',{duration:0.5}) }); <\/script>","protected":false},"excerpt":{"rendered":"<p>Do you have an MS Excel worksheet that is sized just barely over the width of a page? If so, if you need to print it on one page only, that extra width is a problem, isn&#39;t it? So, what did you do? Maybe you went back to the worksheet and started adjusting the column [&hellip;]<\/p>\n<!-- Social Bookmarks BEGIN -->\n<div class=\"social_bookmark\">\n<a title=\"Click me to see the sites.\" href=\"#\" onclick=\"$$('div.d427').each( function(e) { e.visualEffect('slide_down',{duration:2.5}) }); return false;\"><strong><em>Bookmark to:<\/em><\/strong><\/a>\n<br \/>\n<div class=\"d427\" style=\"overflow:hidden\">\n<br \/>\n<br \/>\n<a style=\"font-size:90%;text-align: right; \" title=\"Click me to hide the sites.\" href=\"#\" onclick=\"$$('div.d427').each( function(e) { e.visualEffect('slide_up',{duration:0.5}) }); return false;\">Hide Sites<\/a>\n<\/div>\n<\/div>\n<!-- Social Bookmarks END -->\n<script type=\"text\/javascript\">$$('div.d427').each( function(e) { e.visualEffect('slide_up',{duration:0.5}) }); <\/script>","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[32],"tags":[],"_links":{"self":[{"href":"https:\/\/alsplace.info\/index.php?rest_route=\/wp\/v2\/posts\/427"}],"collection":[{"href":"https:\/\/alsplace.info\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/alsplace.info\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/alsplace.info\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/alsplace.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=427"}],"version-history":[{"count":0,"href":"https:\/\/alsplace.info\/index.php?rest_route=\/wp\/v2\/posts\/427\/revisions"}],"wp:attachment":[{"href":"https:\/\/alsplace.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=427"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/alsplace.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=427"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/alsplace.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=427"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}