- Excel Book Excerpt
Excel Move Columns Using Insert Cut Cells
This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.
Move Columns Using Insert Cut Cells
Problem: I need to rearrange two columns. The left-to-right sort trick described in “Move Columns by Sorting Left to Right” seems overly complex.
Strategy: There is a fast way to move a couple of columns. You select the entire column to be moved and use Cut. Then you right-click on the column to the right of where the data should go and choose Insert Cut Cells.
Below, you want to move column B before column A. This will require four clicks. Follow these steps:
1. Right-click the B column label. Choose Cut from the context menu.
Figure 1178 Right-click the column and cut.
2. Right-click the A column label. Choose Insert Cut Cells.
Figure 1179 Cut B and insert cut cells before A.
Results: The entire column will be moved. This is an amazingly simple and fast process.
For more resources for Microsoft Excel: