To swap columns in Excel, you need to use the drag-and-drop method. However, if you want to replace an existing column entirely, you can select the new column, put your mouse over the borderline ...

An Excel sheet with an arrow indicating where to double-click to change column width. The AutoFit Column Width in Excel's Format drop-down in the Home tab is selected.