Jul 07 2022 02:55 PM
Jul 07 2022 11:17 PM
without seeing the file it's very difficult to give a proper advise. Generally spoken, if I table cannot be sorted, it has usually to do with it's structure. For instance, it could have merged cells in the header or somewhere within the table.
Could you check?
Sep 25 2023 02:16 AM - edited Sep 25 2023 05:28 AM
I see you've been wrestling with this issue for a while now since the thread is about a year old. If you're still facing the problem, there are a couple of things you might try. Firstly, check if the sheet has any merged cells. Merged cells can mess up the sorting functionality in Excel. You could unmerge those cells and try sorting again. Since you're working between Google Docs and Excel, you may want to check out https://docsandslides.com/google-docs/ for templates that might make your workflow a little easier, especially when it comes to spreadsheet functionalities.