Microsoft® Office Excel® 2007 Plain & Simple

Naming and Using Worksheet Views

After you’ve set up your Excel worksheets so that you can read them effectively, you don’t need to re-create the arrangement every time you run Excel. Instead, you can record the arrangement, which includes splits, frozen rows and columns, and hidden cells, in a view. Views are especially handy for worksheets that will be used by different people, all of whom need different information. Different views can be created for each person, so if the data one person would view spans many columns, you can set the print settings to Landscape mode for that view.

Name the Current View of the Worksheet

1. Arrange your Excel ...