how do i sort multiple columns?

[neto333]

Hi, i have 1000 columns with 400 rows each, and im trying to sort them by ascending order, however when i select all the columns and press sort it only sorts the first column.

[63falcondude]

Hello and welcome to the forum.

The sort feature is built to either sort all columns together or one at a time.
If you chose to sort them all together, it will keep rows together so that your data doesn’t get mixed up.

What you’re looking to do is not a standard use of Excel and will therefore require VBA.

I’m on my phone at the moment so can’t test this but it looks like it will do what you’re looking for:
https://www.extendoffice.com/documen...pendently.html