Grouping and Sorting

  • Thread starter Thread starter denv
  • Start date Start date
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!
:( :o
 
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.
 
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.)
 
Back
Top