Error when trying to sort an Excel file

Hi @JackieMcMahon,

Thank you for posting your question in the Microsoft Q&A forum.

According to your concern, that's a very common error message when a PDF is converted to Excel since it often creates merged cells to mimic the PDF layout.

To resolve this issue, you need to find and unmerge all the merges by:

• Go to Home tab > Editing > Find & Select > Find

• Click Options > Format > Alignment tab > check Merge cells only and press OK.

• Then click Find all > it will list all the merges in your file. Click on it to jump to the merge cell and unmerge it

• In case if you want to mass unmerge a whole worksheet, you can do that by clicking on any cell > press Ctrl + A > go to Home tab and select Unmerge cell. However, it may accidentally break the structure of your data so please be careful when you consider mass unmerging.

For further assistance, please share smore details of your current worksheet so I can clearly understand the situation and provide the most appropriate guidance for your concern.

Please understand that our initial response may not always resolve the issue immediately. However, with your help and more detailed information, we can work together to find a solution.

Thank you for your understanding and cooperation. I look forward to hearing from you.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.