Auto sort rows based on value in column G (range of rows is A:K)

[ElleD]

I'm wondering how to set up an excel sheet so that its rows automatically sort based on the value entered in column G (ascending order; the values will be 0, 1, 2, or 3). The rows extend from column A to column K, and I have about 150 rows in total, but more will be added over time. Thanks!

 

[AFPathfinder]

Do you mean filter or are you looking for a custom sort?

On the Home tab → Sort & Filter: Custom Sort... → Order column combobox: Custom List...

If you're looking to sort horizontally within a row, you may need to resort to VBA for a solution.

 

[ElleD]

Thanks for the response! I ended up figuring it out. I wanted it to autosort as I input values over time, so I used a VBA (I was just initially uncertain about the coding when the column to be sorted by was in the middle of a range).