1. Enter a search phrase in the Tell me box about what you want to do.
Complete guide to Excel 2016 (Part 1): Get familiar with Microsoft Excel Picture 13
2. The results will give you some relevant options. To use, click on an option.
Complete guide to Excel 2016 (Part 1): Get familiar with Microsoft Excel Picture 14
View the worksheet
Excel 2016 has many options to change how your spreadsheet is displayed. These views may be useful for different tasks, especially if you are planning to print spreadsheets. To change the worksheet view, look for the commands in the bottom right corner of the Excel window and choose Normal view , Page Layout view or Page Break view ( View page break ).
Complete guide to Excel 2016 (Part 1): Get familiar with Microsoft Excel Picture 15
Normal view is the default view for all spreadsheets in Excel.
Complete guide to Excel 2016 (Part 1): Get familiar with Microsoft Excel Picture 16
The page view shows how your spreadsheet will appear when printed. You can also add titles and footers in this view.
Complete guide to Excel 2016 (Part 1): Get familiar with Microsoft Excel Picture 17
Page break view allows you to change the page break location, especially useful when printing multiple data from Excel.
Complete guide to Excel 2016 (Part 1): Get familiar with Microsoft Excel Picture 18
Backstage view function
The Backstage view function gives you different options to save, open files, print and share Workbook files in Excel.
To access Backstage view:
1. Click the File tab on the Ribbon. The Backstage view will appear.
Complete guide to Excel 2016 (Part 1): Get familiar with Microsoft Excel Picture 19
Click the illustrated buttons in the interaction below to learn more about how to use the Backstage view .
Complete guide to Excel 2016 (Part 1): Get familiar with Microsoft Excel Picture 20