How To Group Rows In Excel

How To Group Rows In Excel Video

How To Group Rows In Excel Video Transcript

we are in Excel 2013 I'm going to show
you how to group and ungroup sections of
data in both columns and rows so let's
go ahead and start with grouping columns
so we'll go ahead and choose the G H and
I columns and then we'll click on the
data tab at the top and then go over to
group and now we see that it grouped
these three together you can also double
click on it and it will make that go
away but they're still technically
grouped so we'll go ahead click the plus
that will show them again now let's do
the same thing with rows so we'll go
over and highlight these rows and we'll

choose Group and now we see the rows are
grouped and the columns are grouped and
again we can collapse that as well as we
want all right now if we decide we no
longer want to see these columns or rows
grouped then we can choose to ungroup
them just again highlight those
particular ones and go over and choose
ungroup
so that's grouping and ungrouping in
Microsoft Excel 2013