Microsoft Office Tutorials and References
In Depth Information
l Excel creates a new left
or top margin with a
minus sign.
6
To hide the rows, click
the minus sign.
The rows disappear, and
a plus sign replaces the
minus sign.
6
l To display the rows again, click the plus
sign.
R EMOVE A G ROUP
1
1
2
Click the Data tab.
2
Click Ungroup.
The Ungroup dialog box appears.
l
3
Click to select either the Rows or the
Columns option ( changes to ).
Click Rows if you want to ungroup rows.
Click Columns if you want to ungroup
columns.
3
4
4
Click OK.
Excel removes the group.
Did You Know?
You can nest outlines; that is, you can place one
group of outlined rows or columns inside another.
For example, within each year, you can group each
month, and within each month, you can group
each week.
Did You Know?
You can also hide rows and columns by clicking
and dragging the lines that separate the column
letters or the row numbers. Also, if you click and
drag over column letters or row numbers and then
right-click, a menu appears. Click Hide to hide
the column or row or Unhide to display hidden
columns or rows.
Chapter 1: Boost Your Efficiency
13
 
Search JabSto ::




Custom Search