How do I sort a colum by the value of each cell?

=How do I sort a column by the value of each of it's cells?

Don Cole

A litte more info maybe?
You can use the sort function under data if I understand the problem

Thank you don_quixote,

I want to change column 1 from:

50
100
25

to:

25
50
100

in numeric order.

Don Cole

Thank you PaulM100,

I don't understand what you mean by "Select the entire range".

Don Cole

One of many ways:

1) Left-click on the cell containing 50
2) Right-click and select "Sort" then "Sort smallest to largest"

That's it!

Thank you GeoffW283,

That works for one column.

I tried with several columns and sorted column D.
It didn't work.

How would I do that?
Of course I would want all the other columns to sort respectively.

Don Cole

Just as long as there are no entirely blank columns then Excel should automatically expand the range that it will sort. If you do have blank columns in the middle of the data you want sorted then either remove them or manually select the entire range that you want sorted.

If this is not your problem or if you need more specific advice then please upload your workbook.

To attach a file, first make sure to remove any sensitive/proprietary data and then click on “GO ADVANCED” and then scroll down to “Manage Attachments” to open the upload window. Choose your file then click on “Upload”, scroll down then click on “Close this window”, then “Submit reply”.

BTW - thanks for the reputation points

Rather than copying a sheet I'll send you a screenshot. (Which I know how to do).

Do I have to fill in all those blank spaces?

Don Cole
Workbook.png

So your screenshot is after an attempt to sort by column-D?

No, there is absolutely no need to fill in the blanks. You should be able to left-click anywhere on your data and select from the ribbon Data > Sort. You should then see your whole sort range (at least A1:G33) highlighted. In the Sort dialog box Excel should automatically figure out that you have a header row and you should be able to select Sort by "Setting" then OK.

I can't see any clues in your attached image as to why this would not work. I provided the instructions to upload a workbook in post #9. If these are not clear let me know, or is it that you have too much propriety data?

Thank you GeoffW283

I believe line 10 was the problem.
I don't know where it came from?
I deleted it; then it worked fine.

Don ColeWorkbook2.png

And of course I could not see line 10 in your original image

Glad that you worked it out. If you're all set now then please take a moment to mark the thread as 'Solved' by using the thread tools menu above your first post.

Geoff