Sorting

[Guest]

I would like to create a workbook where I can click on the cells in row one
(the column names) and the workbook will sort the whole row according to the
values in the column. For example, I use Money 2002, and if I click on Num,
Date, or Payee, it will sort each row of data by the Number, Date, or Payee
column. In Excel, I only know how to sort each column individually, so when
I sort a column alphabetically, it doesn't move the other columns along with
them. This would be like sorting in Money by Payee but instead only the
Payees are sorted alphabetically, and the number and date values don't move
with it. I apologize for not knowing how to describe what I am trying to do
with the appropriate technical language. I have tried to learn about sorting
but it all seems very complicated. If I could learn just this one trick, I
could get my household organized without having to spend 10 hours learning
about sorting in Excel. I would be happy to read an Excel training online
but I have looked through them and I don't know which to read although I have
spent a few hours browsing and reading the wrong ones, or maybe not
understanding well enough. I am great with Outlook and all the others but
this one task eludes me. Thank you so much.

 

[Pete_UK]

Here is a link to a website which describes sorting very well:

http://www.contextures.com/xlSort01.html

Hope you like it.

Pete

 

[Guest]

You might want to look into using the AutoFilter option. Highlight all of
the columns you want to be able to sort. From the Data Menu select "Filter"
then "AutoFilter".

You should now see little arrows in each of your column headers. Just click
on the arrow you want to filter/sort by and select the method you want to use.

HTH,
Elkar

 

[Guest]

all you have to do is select ALL the columns you want to sort then sort by
the column you want.All the rows then stay together

 

[Guest]

Sweet! That seems to be an easy and fool-proof method. Now I can create my
shopping list by sorting my inventory according to what I have marked with an
"x" that I am out of. My life just got so much easier!

 

[Guest]

It looks helpful. Thanks!

 

[David McRitchie]

To sort in the manner described to quickly sort on different columns, I would
suggest invoking the sort based on the column that you double click on. Which
would mean installing a double click event macro.
http://www.mvps.org/dmcritchie/excel/sorting.htm#dclick

The macro will select all of the cells internally for you, and will sort from row 2
down, the same as assuming that you have headers. You can modify the
macro to also omit the last row (based on content in Column A) if you like.
After all the Event macro would only apply to sorting the worksheet you install it with.

BTW, use of the sort buttons is very unreliable. because of the hit or miss on
whether your data has headers or not.

all you have to do is select ALL the columns you want to sort then sort by
the column you want.All the rows then stay together

eludes me. Thank you so much.