Forum Discussion

davisgravel's avatar
davisgravel
Copper Contributor
Jan 09, 2024

sorting numbers

I know almost nothing about excel, i'm trying to sort numbers in ascending order, left to right i have 5 columns of numbers and 1962 rows, can i sort multiple rows at one time? I can't even make it sort multiple rows by doing custom sort and adding levels

  • davisgravel's avatar
    davisgravel
    Copper Contributor
    Thanks for your reply, I have been able to do what you're telling me but, when I sort any number of rows and then try to sort another selection of rows the previous rows that I sorted return to a jumbled state. Also, I have so many rows to sort, I would like to be able to sort a large number of rows at once, guess you would say a range of rows like 1 - 100 or 1 - 1000, is that possible? Without just adding levels 1, 2, 3, and so on. And once again, why does my first sort return to unsorted when i do a second sort?
    • peiyezhu's avatar
      peiyezhu
      Bronze Contributor
      why does my first sort return to unsorted when i do a second sort?

      Can you share some data and expected result for better understanding?

Share

Resources