Grouping rows together

[Guest]

Hello all,

I have a table that has about 4 columns and hundreds of rows. I have already
sorted all of the columns by the customer numbers. Each customer number has
between 1 and 50 rows. What I need to do is group all of the similar customer
numbers together without using a filter. I would like them grouped so that I
can use the expansion button to view all of the lines for that one particular
customer number. Is there a fast way of doing this without going through the
whole sheet and clicking on "group"?

thanks for the help,
Steve-o

 

[Dave Peterson]

I like to use Data|subtotals (and ignore the subtotal row if it doesn't apply).

But you could do your grouping via Data|Group.

One is manual and one is quick.