you can move more than one column at a time by holding down the shift key on your Mac or PC while clicking multiple columns. How to move columns in Excel to replace another column 1. Select a ...

If you want to base the columns on a fixed width, see the next section. 4. Click "Next." 5. Select one or more delimiters — in other words, what Excel should use to know how to separate the columns.