Custom Views

Excel's custom views feature lets you create multiple views of a workbook file. A view includes the window size and position, the active cell, the zoom percentage, hidden columns and rows, and print settings. Once you set up a view, you can choose it from a dialog to see it quickly.

Tip

  • Including print settings in views makes it possible to create and save multiple custom reports for printing.

To add a custom view

1.
Create the view you want to save. Figure 45 shows an example.
Figure 45. Create a view you'd like to save.

2.
Choose View > Custom Views (Figure 46).
Figure 46. Choose Custom Views from the View menu.
3.
In the Custom ...

Get Microsoft Excel X for Mac OS X: Visual QuickStart Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.