Jun 30 2022 03:32 AM
Hi, I'm using Office 365, and have a fairly old spreadsheet originally compiled in an older version.
I'm trying to sort the data; I tick the box that says my data has header rows, and this is ignored. The header row is being sorted.
There are no cells frozen, the header row is bold, and I've made sure the spreadsheet is saved into the latest version of Excel.
What can I try next?
Thanks all.
Jun 30 2022 03:41 AM
Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.
Jun 30 2022 03:53 AM
Jun 30 2022 04:22 AM
Glad you found a workaround/solution.