Warning: A non-numeric value encountered in /home/ingenui5/public_html/wp-content/themes/Builder-Cohen/lib/builder-core/lib/layout-engine/modules/class-layout-module.php on line 505

The fastest way to rearrange columns on a spreadsheet

It isn’t cut and paste. It isn’t even drag and drop.  And here’s one that Microsoft tutorials won’t tell you:  insert a blank row above the headers of your spreadsheet and assign each column a number representing the order the columns need to appear on the revised spreadsheet, and then sort the entire spreadsheet by row (left to right).  Finally, delete the row you inserted. Depending on the number of columns you’re sorting, this may be the easiest.  However, if you have a 40-column spreadsheet, and they’re all out of order, and you have to do the same sorting task once a month, you should consider getting a custom program that reads the spreadsheet of the month, and then rewrites it in the correct order.  After the custom program has been written and tested, this is the fastest solution.

Leave a Reply

Your email address will not be published. Required fields are marked *