As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

How to Swap Columns in Excel: A Step-by-Step Guide

If you're working with data in Microsoft Excel and find the need to rearrange columns quickly, there's a simple keyboard shortcut that can make this task efficient. Here's a step-by-step guide:

Step 1: Select the Columns to Swap

  1. Select Columns:
  2. Click on the column header of the first column you want to swap.
  3. Hold down the Shift key.
  4. While holding down the Shift key, click on the column header of the second column you want to swap.
  5. This will select both columns.

Step 2: Use the Keyboard Shortcut

  1. Apply the Shortcut:
  2. With the selected columns, use the keyboard shortcut:
  3. To swap left: Press Alt + Shift + Left Arrow.
  4. To swap right: Press Alt + Shift + Right Arrow.
  5. The selected columns will move accordingly.

Step 3: Repeat as Needed

  1. Repeat the Process:
  2. If you need to swap additional columns, repeat the process.
  3. Select the columns and use the keyboard shortcut to move them left or right.
  4. Continue this until you have the columns arranged in the desired order.

Note: Ensure that the cells in the selected columns do not contain data that you need to keep track of, as the swap action will move the entire columns.

And there you have it! Using the Alt + Shift + Left Arrow or Alt + Shift + Right Arrow keyboard shortcut, you can swiftly swap columns in Microsoft Excel. This method is particularly handy when you have numerous columns to rearrange.