I find I need to do this sometimes if I am building a spreadsheet solution which more than most times needs to be tweaked, until I am finally happy with it. If possible, adding commas as shown but not essential. It is really easy to move a whole Excel data table to a new location on the same worksheet or even a new location on a different worksheet in the same workbook or an entirely different workbook. To do this, you should: Click on any cells in a column. Using keyboard shortcuts is the fastest way to swap two Excel columns. The beauty of Excel here is that you can always undo (‘Ctrl’ + ‘Z’) your actions like dropping the column in the wrong place. But no matter how easy it is, you still have to keep a presence of mind. That would be the key to tell you it is an Excel layout problem. For all rows, I need to move the two letters in col B and col C to the corresponding columns. Swap Two Columns Using Keyboard Shortcuts. Moving columns either in the same worksheet or to another is easy. You should have seen the same messed up results when you select a print preview in Excel (with the Adobe PDF printer selected). Just as a repeat, this is an Excel issue and that is where it needs to be fixed. I am just trying to explain the process so that you can layout what you want so it will print correctly to a PDF. If you have a different printer selected as you edit and then print to the Adobe PDF printer, the output may be different than during editing (including bookmarks locations and such if PDF Maker is used).

Adjust the layout in Excel until it is as you need, then print it to the Adobe PDF printer (or use PDF Maker). Thus the document will flow correctly for the Adobe PDF printer.

It is important with OFFICE products to have the printer selected as you edit a document if the layout for printing is important (this is an OFFICE feature, not Acrobat). If you select the Adobe PDF printer (I did not say to print, just select), you can then preview and also see the layout in Excel of how the document will print.

Moving columns in excel table