Grouping and Sorting

D

denv

Hello
Im wondering what grouping does? It's in the data dropdown and under
group and outline. Also I was wondering if there is a way do sort a
table without messing up the dat that is there. I have a table and it
it has all the data of x but when I sort in the data shuffle s up and
some cells have the message #VALUE!
:( :eek:
 
D

Dave Peterson

Have you ever used Data|Subtotals to get subtotals based on the value in a
column. You get those outlining symbols to the right of the worksheet's row
numbers.

Well, you can do the same kind of thing manually. Just select a nice range (say
A3:a10) and do data|Group and outline|Group.

You can do the same thing going across the columns, too.

You can see more info if you look up "Outline" in Excel's help.
 
D

Dave Peterson

And my first guess about the sort is that you're sorting a subset of what you
want to sort. Try selecting the entire range, then do Data|Sort.

(If that's not the cause, maybe your formulas are getting sorted weird. You may
want to post an example of your formula.)
 
Top