![]() Note that you can insert as many page breaks as you want.įor example, if you want to print the data for each region on a different page, you can insert multiple horizontal page breaks by selecting the row right below where the data for that region ends and inserting a page break there. Simply select the column B for which you want the page break to be added and go to the ‘Page Layout’ tab and click on the ‘Insert Page Break’ option Just like the way I have inserted a horizontal page break in Excel, you can also insert a vertical page break. ![]() You may not be able to see this line if you already have the gridlines visible, but if you hide the gridlines you would be able to see this as shown below. The above steps would insert the page break right above the selected row.Įxcel also shows you the positions of the page breaks by adding a light gray dotted line between the two pages. Click on the ‘Insert Page Break’ option.In the ‘Page Setup’ group, click on the ‘Breaks’ option.Select the row above which you want to insert the page break.So to do this, I’ll have to manually insert a page break after the data for the US. If I go ahead and print the data as of now, everything would be printed on a single page because the data is not big enough to be split into multiple pages. In this data, I want to print all the records for the US on the first phase and then all the remaining records on the second page. Suppose I have a data set as shown below where I have the sales numbers for different people working for different regions. Manually Inserting Page Breaks in Excel (Horizontal/Vertical) Check Page Break Insertion from the Page Break Preview.Manually Inserting Page Breaks in Excel (Horizontal/Vertical).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |