Paul Wherly

Workbook Views in Microsoft Excel 2010

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

ExcelView1

  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

ExcelView2

  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.

 ExcelView3

To switch to Page Layout View via the Ribbon

ExcelView4

  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

ExcelView5

  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]

 

Shelley Fishel

 

 

Contact us

Would you like to talk through your IT Training needs?
Just send through your details and we'll get back to you.

More