Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
excel question?
Is it possible to sequentially organize a column in excel, I am trying to organize raw data listed in columns either by zip code or city name. What i'm looking for is how to have one column put all the like zip-codes in order so i can group easier. Is this even possible?
7 Answers
- 1 decade agoFavorite Answer
Yup.
Data >> Sort
Then choose which columns you want to sort by. Most likely whatever column has the area codes.
Source(s): Mi cabeza - JustBeingMeLv 41 decade ago
Yes...once all your information is in you highlight all the columns, go to the menu under DATA then SORT. It allows you to sory by either 1, 2 or 3 columns in either ascending or descending order.
- Darren0901Lv 71 decade ago
If you are talking sorting by a column here is a like that explains out to do that.
Source(s): http://www.mrexcel.com/tip093.shtml - 1 decade ago
Yes
1. Click on the Column you want to sort.
2. look for the Sort button and click on it. It should sort the column and the entire workbook accordingly.
Source(s): Inate knowledge. - How do you think about the answers? You can sign in to vote the answer.
- Anonymous1 decade ago
There is not much of work
ex:expenditure for a house.payments to builder, payment to House loan, EMI(EQUALMONTHLY INSTALMENTS},INPUT IN THE CLUMNS TOTAL LOAN.INTEREST IF BIG AMOUNT IN A BANK
THESE DETAILS IN COLUMNS.ALLTRANSACTIONS. CAN BE DONE BALANCES @RIGHT COLUM
VERY SIMPLE.SAVE TOO
DONOT USE CERTAIN MULTIPLYING FORMULAS AT TOP .YOU ONLY CONTROL NOT THE P.C
I DID FOR 5 YEARS.FOR MY DEAR ONE.
- Anonymous1 decade ago
First, select the data you want to sort. Then click Data menu, and Sort, then select the properties you want (ascending, descending, etc.)
- Anonymous1 decade ago
yes, there should be a way to alphabetize it. look on help