Most valuable professional
  • 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.

LE10001217.jpg 

Figure 1178 Right-click the column and cut.

2. Right-click the A column label. Choose Insert Cut Cells.

LE10001218.jpg 

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.

<-Previous Topic                    Next Topic->

For more resources for Microsoft Excel: