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
Arrange your Excel window as you would like it to appear.
Click the View tab.
Click Custom Views.
Click Add.
Type the name of the view.
Select what you want included in the view.
Click OK.
Switch to Another View of the Worksheet
Click the View tab.
Click Custom Views.
Click the view you want.
Click Show.
Tip
To delete a custom view, on the View tab, in the Workbook Views group, click Custom Views. Then, in the Custom Views dialog box, click the View you want to delete and then click Delete. Click Yes to verify that you want to delete the custom view and then click Close.
Caution
You can’t create a custom view in a workbook that contains an Excel 2007 data table.