The result is a line between rows 16 and 17.
Then, in the Page Setup section, click the Breaks icon and select “Insert Page Break” from the drop-down list. To do this, we would click on cell A17, the first cell for Region 2. We can do this by inserting a page break in Excel between each region. A better way to print the document would be to print each region on a separate page. If we print the document as is, Region 2 and Region 3 will split across multiple pages and be mixed in with the other regions. Our sample Excel spreadsheet has data for four separate regions. 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)
