Select cell C5 as shown below and click Page Layout tab > Breaks button > Insert Page Break commandįigure 5. Remember that page breaks are added above and to the left of the cell that we select. Select the cell where we want to add page breaks.Page breaks can be manually inserted through the following procedure: In order to view the page breaks in our Excel file, we simply click the Page Break Preview at the bottom of the window.Īnother method to display the Page Break preview is by clicking the View tab then the Page Break Preview command.īelow window is the Page Break preview, where there are blue lines defining the edges of the page and the rest of the background is in gray area.įigure 4. The automatic page breaks are inserted by Excel based on several settings such as margin, scale, paper size and the manual page breaks that we insert.īefore we learn how to remove page breaks, let us first have an overview of page breaks and how we insert them in Excel. There are two types of page breaks : solid lines that are manually added page breaks, and dashed lines that are automatically added by Excel. A page break is the line divider that marks the edges of each page. An Excel worksheet is separated into pages prior to printing.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |