Thursday, February 16, 2012

How to Move a Column in Microsoft Excel


1. Open the Excel workbook to the worksheet containing the column you want to move. If you are moving it to a different workbook, open the second workbook to the target worksheet as well.
2. Click in the column header for the column you want to move. Use the built-in Excel column header with the pre-assigned letter, not a user-entered column header. Clicking the built-in header will select the entire column.
3. Press the 'Ctrl' and 'X' keys simultaneously to cut the column from its original location.
4. Click the column header to the right of where you want the column inserted, whether it is in the same worksheet or elsewhere. This will highlight the column you just clicked.
5. Press 'Ctrl' and 'V' simultaneously. This will paste the column to the left of your highlighted area, moving it to your target location.

Blogger news