"Excel View Options - Page Layout, Page Break and Normal View"


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:

  • Page Layout - displays worksheets as they would appear if you printed them out;
  • Page Break Preview - displays the page breaks as blue lines, as described in the first Tip on the next page; and
  • Normal - normally use this view for building and editing worksheets.

Besides that, 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.

This article shows you how to switch to different views in Excel 2010.


To switch to Page Layout View

  • Click the View tab.
  • In the Workbook Views group, click the Page Layout icon. You can also click the Page Layout button located at the Status bar.
  • page layout view
  • Excel switches to Page Layout view.


To switch to Page Break Preview

  • Click the View tab.
  • In the Workbook Views group, click Page Break Preview icon. You can also click the Page Break Preview button located at the Status bar.
  • The Welcome to Page Break Preview dialog box appears, click OK.
  • Excel switches to Page Break Preview.


To switch to Normal View

  • Click the View tab.
  • In the Workbook Views group, click Normal icon. You can also click the Normal button located at the Status bar.
  • Excel switches to Normal view.


Related Topics:

Applying Gallery Effects to The Spreadsheet Objects in Excel 2010

Discover the Excel 2010 Smart Tags Feature!



Can't find what you're looking for? Try Google Search!

Custom Search


Back to Top

You're viewing the Excel view options info page, click here to go back to the Home Page

Add To Your Social Bookmarks: add to BlinkBlink add to Del.icio.usDel.icio.us add to DiggDigg
add to FurlFurl add to GoogleGoogle add to SimpySimpy add to SpurlSpurl Bookmark at TechnoratiTechnorati add to YahooY! MyWeb


Google Search:

Custom Search

Recommended Resources:

Click on the image to view the details of the training/book.
Excel 2010 formulas ebook
Microsoft Excel 2010 Formulas


Excel 2007 ebook
The Ultimate Guide to
Excel 2007!


PowerPoint 2007 ebook
The Ultimate Guide to
PowerPoint 2007




XML RSS
What is this?
Add to My Yahoo!
Add to My MSN
Add to Google


Enjoy This Site?
Then why not use the button below, to add us to your favorite bookmarking service?

Copyright © www.msoffice-tutorial-training.com. All Rights Reserved.