software

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 quot;groupquot;?

thanks for the help,
Steve-o

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.

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

--

Dave Peterson