BleepingComputer.com: Excel

Well i got excel - spreadsheet and i have a list of things and its like 1-100 but its all in a different order like


(Example)

3
7
98
95
39

But i want as like

1
2
3
4
5


If you use it, can you screenie it and show me.


Thanks.

Select the reange which you want sorted, then use the Main toolbar > Data > Sort

There's also a button on the standard toolbar with AZ and a downarrow, you can use that.
If you do not have the button visible, you can bring it back:
Main toolbar > View > Toolbars > Customise, click on Data under Categories, then from the Commands side drag the Sort commands over to the Standard toolbar.

Finally, Help and ask about "sort".

True, but make sure you click the uppeer left corner of the sheet to select all data or you'll sort your numbers and the contents (if you have some) will stay where it is.

I respectfully disagree.
Selecting the entire worksheet only makes sense if said worksheet contains only one type of data contents.
Therefore the wording "select the range of data to sort" is correct and does not exclude the option of selecting entire sheet when it makes logical sense to do so, and does include multicolumn range selections. So if you have a list of people in col.A, money they owe you in col.B, date due in col.C, of course the range to select must include all the data in those three columns, else sort will mangle the data. Bright spot - UNDO works fine.

tryn2learn, please imagine a worksheet with several data ranges. Perhaps a bunch of little lookup tables for data entry ease in addition to your 'main' data area in a contiguous bunch of cells. Lookup tables are normally referenced by a range of cells, and may even be in hidden columns. Sorting of the entire sheet would totally destroy the design.

tos226,
I stand corrected, you are absolutely correct. I read the question as if it were a simple spreadsheet, only one type of data content.