Sort columns in Excel like in Explorer's detailed view?
Docano
Texas
There's a way to setup columns in Excel where if you click the column heading at the top of the column it sorts all the items in the column below it, similar to how, in windows explorer's detailed view, you click on the Name column heading it sorts the file names in ascending order and if you click Name again, it does it in ascending order. It's been about 5 years since I've done it, but I do know it's possible in Excel. I've just forgotten how. Could one of you help me out?
Thanks~
Thanks~
0
This discussion has been closed.
Comments
Then if you have the default tool bars there will be 2 icons One is an A over a Z with and arrow pointing down the other is a Z over an A with an arrow pointing up. Those are the quick ascending/descending buttons. If you don't have them click on the data tab then sort then it'll ask you more detailed info on how you want things sorted.
Keep in mind that if you use the quick sort buttons that it'll only sort the column you have highlighted. So if information in column A is releated to column B then you need to highlight both sets of columns so they are sorted together and your data doesn't get screwed up.
Given a row of column headings in Excel, let's say from A:2 through A:5 (Name, Size, Type, Modified), there's a way, though I don't remember how, to select those headings and convert them into four separate buttons that, when you click them, perform the same kind of sorting action as they do in Windows Explorer's detailed view. The method of sorting you suggest works but is too much work to do for large spreadsheets. I want to setup columns like I describe here and sort columns that way. Does that make sense?
Like I said, I know it's possible. I just don't remember how.
Thanks for your help
Maybe it was something other than Excel I used to do it in high school.
Thanks again and sorry if this post sounds unappreciative.