O'Reilly logo

Learn Excel 2011 for Mac by Guy Hart-Davis

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Custom Views

When you need to keep your data laid out in a particular way, you can create a custom view. To do so, follow these steps:

  1. Set up the workbook exactly the way you want it. For example:
    • Display the worksheet you want to see.
    • Hide any columns and rows you don't want to view. You'll learn how to hide columns and rows in Chapter 4.
    • Switch to the view you want.
    • Zoom the view as needed.
    • Set the print area.
    • Apply any filtering needed (see Chapter 10).
  2. Choose View images Custom Views from the menu bar to display the Custom Views dialog box (shown on the left in Figure 1–36 with two views already added).

    Figure 1–36. Use the Custom ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required