Remove Page Break:The Manual Page Breakthat was inserted will be removed. Insert Page Break:A Page Breakwill be inserted depending which is the activated Cellin our Spreadsheet. Once we select the command Breaks, from the drop-down menu that appears we have the following commands available and which are: Once we have located the Page Setup area of the Page Layout tab, we select the command Breaks as shown in the image below. If we want to Insert our own Page Breaks and not to use the Automatic ones, we must select the Page Layout tab and then locate the area of the ribbon named Page Setup as shown in the image below. The Dotted Blue Lines Vertical and Horizontal means that they are Automatic Page Breaks. We also notice that we have besides the Straight Blue Lines (both vertical and horizontal), Dotted Blue Lines Vertical and Horizontal. We also notice that the Pages order goes from Top to Bottom and then from Left to Right, a feature that can be changed and will be described in a future post of mine. Once we have dragged the lines to the position needed, we notice now that we have four (4) Pages in our Spreadsheet. If we need to adjust the Page Break manually, all we need to do is to click and select either the Horizontal or Vertical Line, or where the lines intersect at the bottom right corner and then drag them with our mouse to the position needed as shown in the image below. The Horizontal and Vertical Blue Line defines a Manual Page Break that we have inserted. We notice the lettering in the middle of the Spreadsheet (which will not be printed) and we notice a Horizontal and Vertical Blue Line which define where the Page ends. In the image below, I have selected the Page Break Preview, where we can see the actual page that will be printed when we decide to. Once we locate the Workbook Views area, we select the command Page Break Preview, where we will be able to See Where The Page Breaks Will Appear When Our Document Is Printed. 
We must select the View tab, and then from the left area of the ribbon we locate the area named Workbook Views as shown in the image below.
To find out, how it is done, just keep on reading the post below.
If we want to Print a Worksheet with the exact number of Pages that we want, we must adjust the Page Breaks in our Worksheet before we print it. In Excel, automatic Page Breaks are inserted depending on the Paper Size, Margin Settings, Scale Options and the positions of the Manual Page Breaks that we have inserted. Page Breaks are dividers that separate our Worksheet into different pages for printing.
0 kommentar(er)
