How to rearrange columns in excel

Answer

To rearrange columns in Excel, select the column you want to move, then drag it to the new position. This method works on both Windows and Mac versions of Excel.

Method 1: Drag and Drop

1. Click on the column header (the letter at the top) to select the entire column
2. Position your cursor on the selected column header until it changes to a move cursor (four-directional arrow)
3. Click and hold on the column header
4. Drag the column to its new position between two existing columns
5. Release the mouse button to drop the column in place

The column shifts to the new location while other columns adjust automatically to fill the space.

Method 2: Cut and Insert

1. Right-click on the column header you want to move
2. Select "Cut" from the context menu
3. Right-click on the column where you want to insert the moved column
4. Select "Insert Cut Cells"

Excel inserts the cut column at the selected position and shifts the existing columns accordingly.

Method 3: Move or Copy Dialog

1. Right-click on the column header you want to rearrange
2. Select "Move or Copy" from the context menu
3. Choose the location where you want the column to appear in the dialog box
4. Click "OK"

This method displays a clear preview of where your column will be positioned before you confirm the action.

Platform Differences

Windows and Mac versions of Excel use identical procedures for rearranging columns. The keyboard shortcuts and menu options remain the same across both operating systems.

Selecting Multiple Adjacent Columns

1. Click on the first column header you want to move
2. Hold Shift and click on the last column header in the range
3. Drag the selected columns to the new position as a group
4. Release to place all columns together

Selecting Non-Adjacent Columns

1. Click on the first column header
2. Hold Ctrl (Windows) or Command (Mac) and click on additional column headers
3. Drag the selected columns to move them together to a new position

Yes · 0 No · 0 Add Comment · 0

Add ·

Report