Excel Data Sorting Tricks
I've prepared a lot of Excel data that has been exported from back office systems and Customer Relationship Management systems over the years to prepare it for PDF automation projects.
In my experience the data is messy and inconsistent more times that not. While not specific to Acrobat or JavaScript, I thought I would share some tips and tricks for organizing Excel data.
Automatic Column Width Sizing
The column widths in the spreadsheet with the exported data are usually the default width, leaving lots of data covered up by the next column. Follow these simple steps to automatically increase all column widths so no data is cut off by another column:
Click the square above the 1 in the row labels and to the left of the A in the column labels. This will select the entire sheet.
Select All Double click any of the lines the separate the column labels.
