Excel will automatically resize the data on the page to fit the height you drag this line to, which can also sometimes lead to the data, when printed, being too small to read. Click the horizontal blue line and hold down the left mouse button to drag the line up or down to include or exclude rows. Excel will automatically resize the data on the page to fit the width you drag this line to, which can sometimes lead to printed data being too small to read.Ģ. Click the vertical blue line and hold down the left mouse button to drag the line to the left or right to include or exclude columns. To resize pages and include or exclude rows or columns:ġ. All the data (numbers, icons, text, etc.) in the dark grey area, will be excluded when you print the worksheet. The feint watermarks denoting and, is an indication of how many pages the worksheet contains and will print to.Ĥ. In the Workbook Views group, click on Page Break Preview.ģ. You can break off columns or rows in exactly the best spot by moving the blue lines of the Excel 2016 Page Break Preview.Ģ.
The Page Break Preview in Excel is a very powerful print preview that allows you to manually move page breaks and reorganize a worksheet into pages for printing. The Normal view in Excel is the most commonly used view and arguably the best view for adding data to a worksheet. In the Workbook Views group, click on Normal.
When you open a new workbook or sheet, it will usually open with this view activated.Ģ. The Excel normal view, which is also the default view for all worksheets, is the easiest view to use for managing data, creating formulas and formatting rows and columns.
#Excel 2016 page break preview free
Test your Excel skills with the corresponding FREE Online Multiple Choice Making Excel View Types Work for You – 2016 Excel Basics Test Using view types effectively is an essential part of worksheet management and layout design. Excel Views Tutorial – Make View Types Work for You – Excel 2016 Tutorial – Learn Excel BasicsĮxcel 2016 Tutorial – Learn Excel Basics Free Online Microsoft Excel TutorialsĮxcel 2016 comes packed with three built-in view types, Normal, Page Break Preview and Page Layout, as well as a set of customizable view options.
0 kommentar(er)
