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 window as you would like it to appear.

  2. Click the View tab.

  3. Click Custom Views.

  4. Click Add.

  5. Type the name of the view.

  6. Select what you want included in the view.

  7. Click OK.

    Name the Current View of the Worksheet
    Name the Current View of the Worksheet
    Name the Current View of the Worksheet

Switch to Another View of the Worksheet

  1. Click the View tab.

  2. Click Custom Views.

  3. Click the view you want.

  4. Click Show.

    Switch to Another View of the Worksheet

    Tip

    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

    Caution

    You can’t create a custom view in a workbook that contains an Excel 2007 data table.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.220.181.186