I have seen similar issues on here and tried all the fixes but none of them seem to work.
We have a spreadsheet with columns A through to FD
Column A is surnames.
When we try to sort data based on surname A-Z the columns A-BZ are all correctly sorting across the rows. But from CA to FD the rows do not sort with the surname.
I have tried highlighting all the cells that need sorting (Column A-FD and Rows 5-111) but even then the columns after CA do not sort.
There is something blocking it from seeing the columns after CA. Multiple staff use this spreadsheet and someone has pasted information and caused this issue but we cannot seem to figure out what.
I really hope someone can help sort as it previously worked for all these columns. I hope I have explained the issue clearly.