Microsoft Office Tutorials and References
In Depth Information
Save time by creating
A CUSTOM VIEW
After you create a worksheet, you may
want to filter your data, hide columns or
rows, or create special print settings. For
example, you may want to keep
information on every quarter of a year in
a single worksheet but be able to present
one quarter at a time. You can filter your
data, hide columns, set print settings,
and save these settings by creating a
custom view. You can then recall the
view whenever you need it.
Did You Know?
To hide columns or rows, select the columns or rows you want
to hide. Click the Home tab and then click Format in the Cells
group. A menu appears. Click Hide and Unhide. Another menu
appears. Click to choose from Hide Rows or Hide Columns.
When you want to display your columns or rows again, click
and drag to select the columns or rows on both sides of the
hidden cells; then on the Home tab choose Format, Hide &
Unhide, Unhide Columns or Unhide Rows.
Hide rows or columns in your
Missing letters or numbers
indicate hidden columns or
Set your print settings by using
the Page Layout tab.
Click the View tab.
Click Custom Views.
l The Custom Views dialog box
l The Add View dialog box
Type a name for the view.
Click to include Print settings
and/or Hidden rows, columns,
and filter settings (
l Excel adds the view.
To use the view, open the
workbook, click View, Custom
Views, click the name of the
saved view, and then click Show.