Excel 2007 Worksheet Views

Zooming In and Out of a Worksheet

There are two basic ways to zoom in and out of a worksheet:

  • View tab – Zoom group
  • Zoom Slider

View Tab

The View tab holds the Zoom group, which provides three commands for changing the magnification level for the worksheet.



  • Click the Zoom button to open the Zoom dialog.

  • Select the desired magnification level, or type a custom level.
  • Click OK.


Click the 100% button to return the workbook’s zoom level to 100%.

Zoom to Selection

Click Zoom to Selection to zoom in to the active cell(s).

Zoom Slider


The Zoom Slider acts like a sliding control moving between minimum and maximum zoom levels.

To use the Zoom Slider, click on the slider and drag it to the right to increase the zoom level, or left to decrease the zoom level.

  • Click the Minimum button to decrease the magnification by 10% with each click.

  • Click the Maximum button to increase the magnification by 10% with each click.


Viewing a Worksheet in Multiple Windows

To view a worksheet in multiple windows, click the New Window button located in the Window group of the View tab.


Notice that the workbook is displayed twice in the taskbar. In the example below, the workbook is named Books!.xlsx. So, we now see Books!.xlsx:1 and Books!.xlsx:2.


The :# indicate the window in which you are working.

Although this looks like two separate documents, it is actually two windows leading to the same document. Changes made in one window are visible in the other.

To move between the two windows,

  • Click the button for the other window in the taskbar. For example, if you’re working in window 1 (Books!.xls:1) click Books!.xls:2 in the task bar to access the spreadsheet through window 2.
  • -or-
  • Click Switch Windows in the Windows group of the View tab and choose the appropriate window from the dropdown list.


Viewing Workbooks Side by Side

To view workbooks side by side,

  1. Open the workbooks to view side by side. (Microsoft Office Button | Open)
  2. Click View Side by Side in the Window group of the View tab.


    The documents will open one on top of the other:


    When View Side by Side is enabled, Synchronous Scrolling is turned on by default.


    This means that when you scroll in one document, the second document is scrolled at the same rate. Synchronous Scrolling is particularly useful when comparing multiple versions of the same document.
    To turn off Synchronous Scrolling, click the button. To enable, click again.

Splitting a Worksheet Window

Splitting a worksheet window allows you to view two areas of the same worksheet at the same time. This is helpful when orienting yourself on particularly long or wide spreadsheets. To split the workbook vertically,

  1. Click the Vertical Split Bar which is located at the top of the Vertical Scroll Box. Notice that the cursor changes to a double-headed arrow.


  2. Drag the Vertical Split Bar to the desired location. The spreadsheet is now split vertically. Each section can be scrolled through separately.

To split the workbook horizontally,

  1. Click the Horizontal Split Bar which is located to the right of the Horizontal Scroll Box. Notice that the cursor change to a double-headed arrow.
  2. Drag the Horizontal Split Bar to the desired location. The spreadsheet is now split horizontally. Each section can be scrolled through separately.

To un-split (horizontally or vertically) the workbook, click the Vertical or Horizontal Split Bar, dividing the sections and drag it back to the original location.

Freezing and Unfreezing Panes

Freezing Panes involves “freezing” specific row(s) or columns(s) so that they remain visible while you scroll through the rest of the worksheet.

For example, let’s suppose you have a worksheet that is too big to be displayed all at once. You have a heading row for your worksheet that you’d like to be able to see when you are looking at the data further down in the worksheet. To do this, we can freeze the header row.

To freeze panes,

  1. Right-click the row header for the row to freeze. In the example below, this is row 1.


    Notice that the cursor changes to a solid black arrow.

  2. Click Freeze Top Row in the Freeze Panes dropdown in the Window group of the View


    The top row of your worksheet is frozen and remains in view when you scroll down in the worksheet.

To unfreeze panes,

Click Unfreeze Panes located on the Freeze Panes dropdown in the Window group of the View tab.

Monitoring Cells with the Watch Window

The Watch Window displays formulas and their results in a watch window. This is particularly useful for large worksheets where the formula may not be visible on the screen.

To open the Watch Window,

  1. Select the cell(s) to watch.
  2. Click Watch Window in the Formula Auditing group of theFormulas tab.


    The Watch Window opens.


  3. Click Add Watch. The Add Watch window opens with the selected cell’s address displaying.


  4. Click Add. The formula is added to the Watch Window.


    If desired move the window to another location so that you are able to work within the worksheet. The window can be docked to the sides or bottom of the worksheet.
    If data is changed in any of the cells within the formula displayed in the Watch Window, the formula results will change as well. This is visible in the Watch Window, so you don’t need to navigate to the cell containing the formula to view the results.

Viewing Using Full Screen

Full Screen view displays the worksheet without the Ribbon or any of the toolbars, displaying the worksheet across the entire screen.

To view the worksheet in Full Screen view,

Click the Full Screen button in the Worksheet Views group of the View tab.


The worksheet displays in Full Screen view.


Notice that the Ribbon and toolbars are not visible in this view.

To exit Full Screen view,

Press ESC on the keyboard or click the Restore Down button at the top right of the screen.

Creating Custom Views

Custom views can be created and used to view the screen with certain criteria in place. For example, we can create a custom view that preserves the zoom level, row and column widths, and has particular columns hidden.

Let’s suppose we have a large worksheet. We are concerned with the data displayed in the MOD Number and Sales Date columns, so need to make sure that they are wide enough for the data within. Additionally, we would like to freeze the top row so that it can be viewed at all points in the worksheet. We would like to hide columns G and I.

Preparing the View

First, let’s look at column D, MOD Number. We need to expand this column as it is not displaying the data within. To do this, double click between D and E on the column header row. Excel automatically resizes the MOD Number column to the correct width. Repeat this process for column L, Sales Date.

Next, we want to freeze the top pane of the spreadsheet. To do this, click Freeze Top Row on the Freeze Panes dropdown of the Window group of the View tab.

Finally, we want to hide columns G and I.

To hide the columns,

  1. Select column G. Notice how the cursor changes to a solid arrow.


  2. Press Ctrl.
  3. Select column I.
  4. With both columns selected, right-click and choose Hide.


Now that we have the worksheet displayed as we want, we can save this view as a Custom View.

To save this view as a Custom View,

  1. Click the Custom Views button in the Workbook Views group of the View tab.


    The Custom Views screen opens.


  2. Click Add. The Add View screen opens.


    Type a name for the view. In this example, we’ll use MOD Data.

  3. Click OK. The Custom View is saved.

Once a Custom View is saved, it can be accessed at any time. To apply a Custom View to the current view,

  1. Click the Custom Views button in the Workbook Views group of the Views tab.


    The Custom Views screen opens.


  2. Highlight the appropriate view and click Show. The worksheet is displayed in the Custom View.

How to Link to This Page

It will appear on your page as:



Search for Tutorials

Excel Tutorials: Excel 2007 Tutorials

Excel 2007 Tutorials
Excel 2007 Charts
Excel 2007 Graphics
Excel 2007 Worksheets
Excel 2007 Worksheet Views
Excel 2007 Formulas
Excel 2007 Named Ranges
Excel 2007 Cell Comments

Excel Video Tutorials
Lesson 1: Excel Basics
Lesson 2: Editing a Worksheet
Lesson 3: Making Bar and Circle Graphs
Lesson 4: Making a Gantt Chart
Lesson 5: Excel Keyboard Shortcuts

More Excel Tutorials at GuidesandTutorials.net

All Other Guides and Tutorials

Guides and Tutorials Blog
Listing of the latest tutorials published on the GuidesandTutorials website.
GuidesandTutorials: Audacity Tutorial - Record and Edit Audio
This Audacity tutorial will show you how to use the basic tools and procedures in the open source audio editing program, Audacity. Not just screen shots, but free narrated multimedia tutorials - You'll learn to use Audacity for recording and editing audio files that can be used for podcasting, mixing music and vocals, creating sound tracks, and other audio projects.
Audacity Tips & Tricks
Audacity tips and tricks submitted by users
Digital Photography Guide
This Digital Photography Guide will provide you with the basic information you need to take professional quality photogrphs with your digital camera.
GuidesandTutorials: Dreamweaver Tutorial
Dreamweaver Tutorial - this series of free Dreamweaver tutorials is just what you need to get up and running with Dreamweaver to create interesting and compelling web sites
GuidesandTutorials: Microsoft Excel 2003 Tutorial
This Excel 2003 Tutorial will introduce you to the basics of using the Excel 2003 spreadsheet program. You'll learn to create a spreadsheet, basic Excel workbook skills, work with cells, enter and manipulate data, apply formulas, format data, create and work with charts, and manage Excel workbooks.
Podcasting Tutorial
This Podcasting tutorial includes a step by step guide that will show you how to record, publish and promote your podcast. Using inexpensive equipment and free software, you'll be publishing podcasts in no time.
PowerPoint Tutorial - Microsoft PowerPoint 2003
This PowerPoint tutorial is just what you need to learn how to use PowerPoint 2003 to create effective and engaging presentations.
The PowerPoint 2007 Window
This PowerPoint 2007 tutorial will show you the features and how to get around the PowerPoint Window.
GuidesandTutorials: Free PowerPoint Templates
Free PowerPoint templates that you can download and use today. This is a growing library of free resources for PowerPoint users.
LCD Projector Guide and Tutorial
This LCD Projector Guide will assist you in the use and purchase of a digital LCD projector or DLP projector. It will discuss the differences between LCD and DLP projectors, size and portability considerations, lamp types and brightness, resolution, image quality and other considerations in the use and purchase of a digital projector.
Word Tutorial: Microsoft Word 2003
This Word tutorial is just what you need to learn how to use Word 2003 to create professional looking documents.
Word 2007 Workspace
This Microsoft Word 2007 Workspace tutorial will acquaint you with the new tools and features in the Word 2007 Window. It's changed significantly from previus versions and even experienced users will find this helpful.
Work at Home Jobs
This Work at Home Jobs tutorial will provide information on ways that you can put your skills and knowledge to use in creating part or full time income while working from home.
Guides and Tutorials: Free Guides and Tutoials Site Map
Free guides and tutorials on podcasting, digital video and audio, Audacity, RSS, multimedia development, educational technology, technology integration, K12 Technology, PowerPoint.
Suggest a New Technology Tutorial
Free Technology Tutorials on software and technology applications including PowerPoint tutorials, Podcasting tutorials, Dreamweaver tutorials, Audacity, Non-Linear PowerPoint, Digital Photography, RSS tutorial, and everything educational technology.
Adobe Acrobat 9 Tutorial
This Adobe Acrobat 9 Tutorial will show you how to create PDFs from MS Office applications, from Multipe files, from web pages and from several other types of documents.
GuidesandTutorials: Free Tutorials
Free Tutorials, software, hardware, and technology applications including PowerPoint, Podcasting, Dreamweaver, Audacity,
Excel 2007 Tutorial | GuidesandTutorials: Free Tutorials
This free Excel 2007 Tutorial will show you how to use all of the begginer and intermediate features in Excel 2007

This site proudly build with Site Build It!

Powered By SiteBuildIt



Excel 2007 Ebook: The Ultimate Guide - $12.95

Excel 2007 Ebook

Get the Excel 2007 Ebook: The Ultimate Guide and receive all of the Excel 2007 tutorials in one handy reference guide. Purchase online easily with your credit card or PayPal and have the Ebook emailed to your email address (pdf format)

Price: $12.95. California residents pay 7.25% Sales tax. Delivered via email.

Excel Video Tutorials
1. Excel Basics
2. Editing a Worksheet
3. Making a Gantt Chart
5. Excel Keyboard Shortcuts

Excel 2007 Tutorials
Excel 2007 Charts
Excel 2007 Graphics
Excel 2007 Worksheets
Excel 2007 Worksheet Views
Excel 2007 Formulas
Excel 2007 Named Ranges
Excel 2007 Cell Comments

More Excel Tutorials at

[?] Subscribe To This Site

follow us in feedly
Add to My Yahoo!
Add to My MSN
Subscribe with Bloglines