To only print part of a worksheet highlight the cells you want to print and select (File > Print Area > Set Area). The dashed lines are the default breaks that Excel inserts automatically. The solid lines are breaks that you have manually inserted. If they are moved they are displayed as solid lines (because they then become manual breaks) It is possible to also drag the print boundaries to include more or fewer columns or rows in your print area.ĭotted lines show where automatic breaks will occur ![]() You can drag the blue page breaks with your mouse to customise the printable area. You can adjust the page breaks in several ways. ![]() ![]() It is just an alternative way to look at your worksheet. It is possible to make other worksheet changes while working in this view, such as changing content, increasing column widths, removing rows etc. To view these automatic page breaks select (Tools > Options)(View tab, Page Breaks). When you have finished you can select (View > Normal).Įxcel will insert page breaks for you automatically. The White area denotes the area that will be printed.ĭefining a Print Area lets you restrict the cell range that is printed. ![]() This lets you see the print area clearly with all the page breaks identified. You can see the range of cells that will be printed by selecting (View > Page Break Preview). The Print Area is the area or range of cells that will be printed.Ī page break defines where one page ends and another one begins.
0 Comments
Leave a Reply. |