Jun 16 2021 02:14 PM
I have exported the PDF document into an excel spreadsheet, but I am needing to sort the information by column "A", but I am getting the message "To do this, all merged cells need to be the same size". How do I handle this without losing information within the document.
Thank you for helping!
Jun 16 2021 02:31 PM
SolutionMerged cells cause all kinds of problems, it is best to avoid them
The relevant headers are in row 3, so select A4:AH452, then click to unhighlight the Merge & Center button, and finally sort on column A.
Jun 16 2021 03:23 PM
Jun 16 2021 11:39 PM
It won't delete anything.
Since merged cells will be unmerged, information that was first displayed centered over - say - columns C and D will now be displayed in column C. But it won't move to a different column.
Jun 16 2021 02:31 PM
SolutionMerged cells cause all kinds of problems, it is best to avoid them
The relevant headers are in row 3, so select A4:AH452, then click to unhighlight the Merge & Center button, and finally sort on column A.