Pin Me

Viewing only one Worksheet in Excel: Mac 2008 and 2011

written by: ktolliver•edited by: Michael Dougherty•updated: 7/1/2011

Do you find it easier to concentrate on an Excel workbook when you see only one worksheet at time? Here are a couple of ways to customize your workspace in Excel: Mac 2008 and 2011 to see only one page.

  • slide 1 of 4

    Changing Excel:Mac 2008 and 2011 Default View Options

    No company can anticipate the desires of every consumer every time. The same goes for Microsoft, try though they may. When you open workbooks in Excel:Mac 2008 and 2011, you are presented with a default screen setup. This default configuration includes a view wherein you see multiple worksheets. Perhaps you have data on only the first page or you want to focus on only one page at a time. If you want to change the view to see only one worksheet at a time, there are two simple ways to configure it. These instructions work for both Excel: Mac 2008 and 2011.

  • slide 2 of 4

    First Way: Use the Standard Toolbar Zoom Option

    Step 1

    Locate the Standard Toolbar at the very top of your Excel file, or workbook. The Standard toolbar is the one that has the commands for “New," “Open" and so on. Commands on the toolbars will appear as icons only, or they may have text under the icons. If you don’t see this toolbar, click the “View" menu on the menu bar across the top of your screen. Choose “Toolbars" then “Standard" to place a checkmark beside it.

    Step 2

    Find the Zoom command on the Standard Toolbar. If your toolbars have only icons, you can identify the Zoom command as a rectangular field with a percentage number in it and a dropdown arrow on the right side of it.

    Step 3Zoom Icon Dropdown 

    Click the dropdown arrow on this rectangle to see a selection of page sizes and other options. Choose “One Page" from bottom of the list.

    Now only one sheet shows up at a time from your workbook.

    One Worksheet in Excel 

  • slide 3 of 4

    Second Way: Customize your Excel:Mac 2008 and 2011 Toolbars

    To make your life even easier, you can customize any Excel: Mac toolbar with a one-click command for displaying one worksheet at a time.

    Step 1

    Click the “View" menu from the menu bar across the top of your screen.View Menu on Excel:Mac Menu Bar 

    Step 2

    Choose “Customize Toolbars and Menus." The Customize Toolbars and Menus dialog box appears.

    Step 3

    Click the “Commands" tab.

    Toolbar Commands Dialog Box 

    Step 4

    Scroll down the list of commands on the right side of the Commands dialog box. Click on “Zoom To One Page" at the bottom of the list and drag it out of the dialog box to any Excel toolbar on your screen. You will see a vertical line showing you where the icon would appear if you dropped it. Drop the command on the toolbar wherever you want it by releasing the mouse button.

    Now you only have to click “Zoom To One Page" on the toolbar to show one worksheet.

    Zoom To One Page Icon on Excel: Mac Toolbar 

  • slide 4 of 4

    References

    • Author’s own experience
    • Microsoft
    • Screenshots provided by the author.