Microsoft Office Tutorials and References
In Depth Information
Outlining to hide and show rows and columns
outlining to hide and show rows and columns
Outlining the rows in a worksheet lets you determine which
rows are displayed, making it easier to focus on the data that’s
important to you. If you want to hide the rows for one set of
products, you can define the rows as a group. You then have the
option to choose which rows that you want to display. The rows
that you hide are gone only temporarily. The data isn’t deleted,
it’s just moved out of your way while you don’t need it. You can
bring it back with a single click.
hide grouped rows and columns
1 Click the Hide Detail button next to the group that you want to
hide.
1
Show grouped rows and columns
1
1
Click the Show Detail button next to the group that you want to
show.
SEE ALSo For information about calculating subtotals for
groups of rows, see “Summing with subtotals and grand totals”
on page 110.
Search JabSto ::




Custom Search