 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / May 2008How do I sort A1 THROUGH F26 alphabetically?
I have columns A through F. Each column has 26 rows with inventory items (text). When I try to sort it, it sorts BY column A and the other columns remain unsorted. Apparently, I can only sort each column separately but I need the items in ALL of the columns to be sorted together. Is there a way to do this? BTW, I'm using Excel 2007. Highlight the entire table (ie, what you want sorted) before executing the sort. Regards, Fred. >I have columns A through F. Each column has 26 rows with inventory items > (text). When I try to sort it, it sorts BY column A and the other columns [quoted text clipped - 4 lines] > > BTW, I'm using Excel 2007. If you are saying that it is not taking the other coloumns along for the sort, c b b h a g becomes a b b h a g then: Excel should sort all of this automatically. If it is not doing so, it is because it is not able to recognize all of your coloumns. You have two options. 1) Select all of the Coloumns, and all of the rows, THEN choose Sort. 2) Make sure every coloum has a heading, and every row in the first coloumn has data. If you are saying that you want to sort each coloum seperately: c b b h a g becomes a b b g a h Then you are going to have to select and sort each coloumn seperately. Excel is designed to assume that each row is a single record, and therefore, all coloums within that row should stay together. Move a4 to a2, then you move b4 c4 and d4 to b2 c2 and d2, because that are all part of the same data. Think name address and zip code. You would not want to sort names without moving the zipcode along with it. Phil > I have columns A through F. Each column has 26 rows with inventory items > (text). When I try to sort it, it sorts BY column A and the other columns [quoted text clipped - 4 lines] > > BTW, I'm using Excel 2007. It still won't sort the other columns. And I've checked the formatting, and everything is the same and correct. It will only sort column A. > If you are saying that it is not taking the other coloumns along for the > sort, [quoted text clipped - 50 lines] > > > > BTW, I'm using Excel 2007. Maybe I should give you an example of what I'm trying to do: I want.. A B C Name Name Name Greg Peter Alice Marcia Cindy Carol Bobby Jan Mike to look like... A B C Name Name Name Alice Cindy Marcia Bobby Greg Mike Carol Jan Peter Instead of... A B C Name Name Name Bobby Peter Alice Greg Cindy Carol Marcia Jan Mike > If you are saying that it is not taking the other coloumns along for the > sort, [quoted text clipped - 50 lines] > > > > BTW, I'm using Excel 2007. Excel cannot sort the way you want. It is built to sort by columns, and preserve the rows they are on. Your best bet is to put all the names in one column. Your other, more difficult option, is to build a macro. Regards, Fred. > Maybe I should give you an example of what I'm trying to do: > [quoted text clipped - 79 lines] >> > >> > BTW, I'm using Excel 2007. I was afraid of that. Thanks for the help. You gave me an idea that I might play with tomorrow. Meer > Excel cannot sort the way you want. It is built to sort by columns, and > preserve the rows they are on. [quoted text clipped - 89 lines] > >> > > >> > BTW, I'm using Excel 2007.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.