Microsoft Office Tutorials and References
In Depth Information
Naming and using worksheet views
Naming and using worksheet views
After you 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 are used by different people, all of whom need
different information. Different views can be created for each
person, so if the data that one person views 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 In the Views group, click Custom Views.
4 Click Add.
5 Type the name of the view.
6 Select what you want to include in the view.
7 Click OK.
3
2
4
5
6
7
Search JabSto ::




Custom Search