tag:blogger.com,1999:blog-1869924468172210809.post5402867543515509294..comments2024-03-22T10:09:26.517+00:00Comments on Not Just Numbers: Excel Tip: Setting the print area and page breaksGlen Feechanhttp://www.blogger.com/profile/12461985809302036952noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-1869924468172210809.post-49642889530808471862017-02-06T06:17:13.426+00:002017-02-06T06:17:13.426+00:00Nicola
You'll need to make sure that the scale...Nicola<br />You'll need to make sure that the scale % below the width and height settings is set the same on each sheet. Logically, you can't then also tell it to fit to a page, as it can only do this by adjusting the size of the characters.<br />One approach that should work would be to fit them all to page, see ehich one has the lowest scale %, and set the scale % of the others to that figure.<br /><br />I hope that helps.Glen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-71908195932522805532017-02-05T01:57:46.745+00:002017-02-05T01:57:46.745+00:00Hi Glen
Do you also have a tip to get pages from ...Hi Glen<br /><br />Do you also have a tip to get pages from different worksheets in a workbook all come out with the same size font? I've found that setting the font size the same on each sheet doesn't seem to work.Anonymoushttps://www.blogger.com/profile/03556624330945465096noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-23782213483154253152017-01-30T14:29:09.107+00:002017-01-30T14:29:09.107+00:00Thanks for the inputThanks for the inputGlen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-30784267901432987652017-01-30T14:13:16.572+00:002017-01-30T14:13:16.572+00:00Glen—
Bless you for mentioning this simple but cri...Glen—<br />Bless you for mentioning this simple but critically important Excel feature! In my book, “Painting with Numbers: Presenting Financials and Other Numbers So People Will Understand You,” I list 18 Deadly Sins of Numbers Presentation. Here’s Deadly Sin #12:<br /><br />12. TO PRINT THE FINISHED REPORT, REQUIRING YOUR AUDIENCE TO DO MORE THAN JUST CLICK THE “PRINT” ICON<br /><br />In other words, be familiar with Print Area, Page Breaks, and Page Setup overall. It is a courtesy to your audience that they may well notice, and they will certainly notice if you overlook it!<br /><br />Randall BoltenPainting with Numbershttps://www.blogger.com/profile/01213659387153806567noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-38379102528481058022017-01-30T11:39:28.747+00:002017-01-30T11:39:28.747+00:00Jim
Don't worry, I regularly find there's ...Jim<br />Don't worry, I regularly find there's a new way to do something that I've been doing the same way since Excel 2003 or before!Glen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-86010072175983174952017-01-30T10:24:11.503+00:002017-01-30T10:24:11.503+00:00hmm… just noticed that there's now selectable ...hmm… just noticed that there's now selectable options on the print preview for this - I've only just upgraded to 2010 (8 months ago!) and still use the old Page Setup dialogue as my first call<br /><br />jimAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-55294877494421525472017-01-30T10:16:25.151+00:002017-01-30T10:16:25.151+00:00How to set page height to automatic:
not obvious ...How to set page height to automatic:<br /><br />not obvious (at least it wasn't to me); you need to set the scrollable number of pages to zero, or delete it (NB you can't actually scroll to zero, you have to type)<br />but very useful (and if you're doing this then you probably want to minimise the left and right margins too)<br /><br />jimAnonymousnoreply@blogger.com