Here is an introduction to Workbook Views in Microsoft Excel 2010.

The Excel View options allow you to view or see the spreadsheet differently. You can adjust the Excel window to suit what you are currently working on by changing the view to match your current task.

Excel offers three different views:

1. Page Layout – displays worksheets as they would appear if you printed them out
2. Page Break Preview – displays the page breaks as blue lines
3. Normal – normally use this view for building and editing worksheets.

In addition, Excel 2010 also allows you to customize your views to include additional information to the view. The Full Screen view allows you to view the spreadsheet in full screen mode.

Normal View

Normal View is the default view in Excel, and you usually use this view to build your spreadsheets.

To switch to Normal View via the Ribbon

1. Click the View tab on the Ribbon
2. In the Workbook Views group, click Normal icon
3. Excel switches to Normal view.

To switch to Normal View via Shortcut Icon

1. Click the Normal button located at the right of the Status bar

Page Layout View

This view displays worksheets as if you were going to print them out.

 

To switch to Page Layout View via the Ribbon

1. Click the View tab.
2. In the Workbook Views group, click the Page Layout icon.
3. Excel switches to Page Layout view.

To Switch to Page Layout View via the Shortcut Icon

1. Click the Page Layout button located at the right of the Status bar

[callout]To learn more about how we can help your staff become proficient and confident in their use of Microsoft Excel 2010 give us a call on 020 8203 1774.[/callout]