Keep in mind, if you were to insert new rows or columns, increase the size of these columns, change font size, margins or other formatting features in the document, the dashed line page break indicators would adjust accordingly. Therefore, everything in columns A through H and rows 1 through 37 will print on the first page. You can also see a dashed vertical line between columns H and I. If you look closely, you can see a dashed horizontal line between rows 37 and 38. Here’s an example of an Excel document that spans two pages when printed. Instead of seeing visual pages on your screen, Excel uses dashed lines between the rows and columns to indicate where the page will break, both horizontally and vertically. The difference is that it may not be as obvious to you where the natural page breaks fall in Excel. The same concept in your Word document applies to your Excel document. This is common when starting a new section or chapter in a book. If you print your Word document, the printed pages will match the document pages on your screen.īut, sometimes in Word, you need to force a page break before the current page is full. When you fill enough words and sentences on one page in your Word document, it automatically inserts another page for you to continue typing. It might be easier to think of how a document in Microsoft Word works. So what exactly defines a page, and why would need to insert a page break in Excel? Similar to a Word Document
After all, Excel feels like an endless stream of blank cells in both horizontal and vertical directions. The concept of setting a page break in Excel may seem strange at first.
0 kommentar(er)
