Problem with sorting

I have a spreadsheet which I want to sort by the rightmost column followed by the column before it. For example sort by column BA and then column AZ. However when I have selected BA and go to choose AZ as the second column it isn’t on the drop down menu. If I then select a 3rd column it does then let me go back and change the second one to AZ. This is OK as a workaround but I would prefer not to have to go through it every time.

You need to select the columns you want to sort. So in this case select AZ:BA, then open the Sort dialog…

1 Like