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
In the sort dialog or in the spreadsheet?
Can you edit your question and share the LibreOffice version you are using. Thanks.