Sunday, November 21, 2010

How to sort table of numbers in ascending way in excel?

I want to sort the data while it is in table of 9 rows and 6 columns.

Can I sort it like this or i have to arrange the data inn one column?How to sort table of numbers in ascending way in excel?
I think it is as simple as left clicking the column you want to sort and click on the assort button on the task bar (its and A and a Z with an arrow next to it)





Each column has its own properties you can adjust but at the end of the day if you want your data laid out a very specific way you can always enter it that way from the beginning. A large part of building a good spreadsheet is getting the design right :)How to sort table of numbers in ascending way in excel?
You highlight the data set of 9 rows and 6 columns. Then click Data, Sort. You will be asked for the column which contains the column which contains the sort order data. When you press OK, the data will be sorted.
Follow the advice from Jerome, but beware the only data sorted is that highlighted, so if your data in rows is organised by say date it will get jumbled.

No comments:

Post a Comment