You may require to change your papers size and alignment to maintain it readable, but at least it earned't spill over onto the following page. It will instantly size to maintain the information going across on the same page. You can repair this with the scaling feature in page setup, but a fast fix can be to choose Match To and put a actually large quantity (like 999) in the second package.
One even more technique on publishing Excel spreadsheets - sometimes there is definitely too much information to be contained reading through across so it cuts off rows and puts them on the following page. One even more matter: if publishing gridlines on your piece would assist improve legibility (you understand, edges around each cell to make adhering to rows/columns less difficult), go back to the Bed sheet tab and verify the Gridlines box. You can also level the spréadsheet up or dówn by a collection proportion, or drive the spreadsheet to printing on a specific settings of web pages across/down (if you would like everything to fit on one pagé, you'd choose 1 page(t) wide by 1 page(s i9000) tall, for example). As you can discover from over, you can modify the placement of the héaders and footers ánd the page márgins on the Márgins tab, and control the positioning (portrait versus scenery) and the page size (letter, legal, ledger, A4, etc.) on the Web page tabs. So, unless you're arranging on taping collectively your spreadsheet into one large piece of papers, you're heading to have a difficult time foreseeing out which quantities proceed with each quarter/category. But then page 2 is definitely lacking the column labels, and if you appear at page 4, none of that will be transported over that significantly into the printout.
If you look closely at these Printing Preview pictures, page 1 is usually great - you can find the line labels (with the financial quarter designations at the best) and the row labels (with the classification titles) on the left.
0 kommentar(er)
