DDigioptimalEditorial guide

How To Move Columns In Excel

A practical step-by-step guide to how to move columns in excel, including preparation, instructions, common issues, tips, and next steps.

Published 2026-07-14

How To Move Columns In Excel cover image

How To Move Columns In Excel

Learning how to move columns in Excel is a fundamental skill for organising your data effectively. Whether you're tidying up a downloaded report, rearranging a project plan, or just want your most important information front and centre, this guide will help. We'll walk you through several easy methods, from the super-quick drag-and-drop to safer techniques that prevent you from accidentally deleting data. This guide is for anyone who wants to manage their spreadsheets more efficiently and with greater confidence, ensuring your data stays intact and your formulas keep working correctly.

Fast Answer

  • Easiest Method: Select the column by clicking its header letter. Hold the Shift key, then click and drag the column's border to its new location.
Less than 1 minute Time needed
Beginner Difficulty
Overwriting data Watch out for

Before You Start

  • Microsoft Excel: You will need a computer with any modern version of Microsoft Excel installed (e.g., Excel 2016, 2019, 2021, or a Microsoft 365 subscription). The steps are also very similar for Excel for Web.
  • An Excel File: Have a spreadsheet open with some data arranged in columns. This can be a simple list or a more complex dataset.
  • Save a Backup: Before reorganising a critical spreadsheet, it's always a good practice to save a copy. Go to File > Save a Copy to create a backup just in case something goes wrong.
Check first: Be mindful of spreadsheets with complex formulas. While Excel is smart about updating cell references when you move columns, it's always best to double-check that your formulas still work correctly after rearranging your data.

Step-by-Step Instructions

Method 1: The Shift-Drag (Safest and Recommended)

This is the best method for most situations because it inserts the column into its new place without overwriting any existing data. It simply shuffles everything along to make space.

  1. Select the entire column. Move your mouse cursor over the letter at the top of the column you want to move (e.g., 'C'). The cursor will change to a small black arrow pointing down. Click once to select the entire column. It will become highlighted.
  2. Press and hold the Shift key. This is the most important part of this method. Keep the Shift key on your keyboard held down for the next step.
  3. Position your cursor on the border. Move your mouse to either the left or right edge of the selected column header. The cursor will change from the black arrow to a four-headed arrow icon.
  4. Click, drag, and drop. With the Shift key still held down and the four-headed arrow cursor visible, click and hold your left mouse button. Drag the column to its new location. You will see a thick green vertical line (sometimes called an "I-beam") appear between the columns where your selected column will be inserted. Release the mouse button first, and then release the Shift key. The column will slot neatly into its new position, and all other columns will shift over to make room.
Tip: The visual cue is key. If you see a thick green line, you are inserting the column. If you see a faint "shadow" of the column you're dragging, you are not holding Shift and will overwrite data.

Method 2: The Cut and Paste (Classic and Precise)

This method is very reliable and is especially useful if you need to move a column a long distance across a very wide spreadsheet, where dragging might be awkward.

  1. Select and Cut the column. First, select the column you want to move by clicking its header letter. Then, right-click on the highlighted column header and choose Cut from the context menu. Alternatively, you can use the keyboard shortcut Ctrl + X. You'll see a dashed, moving border (known as "marching ants") around the column you've cut.
  2. Select the destination column. Now, click on the header of the column before which you want to place your cut column. For example, if you cut column 'F' and you want it to appear where column 'B' is, you must select column 'B'.
  3. Insert the cut cells. Right-click on the header of the destination column you just selected. From the context menu, choose the option Insert Cut Cells. Do not choose "Paste"! Pasting will overwrite the column. "Insert Cut Cells" will place your cut column in the new spot and shift the existing columns to the right.
Important: Always use Insert Cut Cells, not Paste (Ctrl + V). Using Paste will replace the destination column's data with the data from the column you cut, effectively deleting the original data in that location.

Method 3: The Standard Drag and Drop (Quick but Risky)

This is the fastest way to move a column, but it comes with a significant risk: it will overwrite and delete the data in the column where you drop it. This method should only be used when you are sure the destination column is empty or contains data you want to replace.

  1. Select the column. Click the column header letter to highlight the entire column you intend to move.
  2. Position the cursor. Move your mouse to the edge of the highlighted column header until the cursor changes to the four-headed arrow icon. Do not hold the Shift key.
  3. Drag and drop. Click and hold the left mouse button and drag the column over the column you want to replace. When you release the mouse button, Excel will pop up a warning: "There's already data here. Do you want to replace it?". If you are certain you want to proceed, click OK. The column will be moved, and the data that was previously there will be gone.

Method 4: Moving Multiple Columns at Once

You can easily apply the safe Shift-Drag or the Cut and Paste methods to move several columns together as a single block. This saves a huge amount of time when reorganising large datasets.

  1. Select multiple columns. There are two ways to do this:
    • For adjacent columns: Click on the first column's header, then hold the Shift key and click on the last column's header in the group. All columns in between will be selected.
    • For non-adjacent columns: Click on the first column's header, then hold down the Ctrl key and click on the individual headers of the other columns you want to move.
  2. Move the group of columns. With your multiple columns selected, you can now use either the safe Shift-Drag method or the Cut and Paste method as described above. The entire block of selected columns will move together to the new location.

Common Problems When You Move Columns In Excel

Even a simple task can sometimes go wrong. Here are some common issues you might face and how to quickly solve them.

Problem: I accidentally overwrote important data.

This is the most common issue, usually caused by using the standard drag-and-drop method instead of the Shift-Drag method.

Solution: Immediately press Ctrl + Z (or Cmd + Z on a Mac) to undo your last action. Your overwritten data will be restored. To avoid this in the future, always try to use the Shift-Drag or Cut and "Insert Cut Cells" methods, which are non-destructive.

Problem: My formulas are showing a #REF! error.

This error means a cell reference in your formula is no longer valid. While Excel is very good at updating formulas when columns move, this can sometimes happen if the column that was moved was explicitly deleted by an overwrite, or if the formula uses complex functions.

Solution: First, try undoing the move with Ctrl + Z to see how the formula was originally structured. Then, perform the move again using a safe method. If the error persists, you will need to manually edit the formula. Click on the cell with the error, look at the formula bar, and correct the cell references to point to the new locations of the data.

Problem: The "Insert Cut Cells" option is greyed out.

This happens when you haven't properly cut a column to the clipboard. You might have copied it instead (Ctrl + C), or you may have clicked somewhere else after cutting, which clears the clipboard.

Solution: Go back to the column you want to move. Select it again by clicking the header, then right-click and explicitly choose Cut (or press Ctrl + X). Immediately go to your destination column, right-click its header, and the "Insert Cut Cells" option should now be available.

Advanced Tips for Moving Columns

Once you've mastered the basics, these tips can help you work even faster and handle more complex spreadsheets with ease.

  • Swap Two Columns Instantly: To swap the position of two adjacent columns, say Column B and Column C, you don't need a temporary holding spot. Simply select Column C, then hold Shift and drag its border to the left edge of Column B. When you release, Excel will insert Column C before B, effectively swapping them in one move.
  • Use Keyboard Shortcuts for Speed: For keyboard purists, you can move a column without touching the mouse.
    1. Navigate to any cell in the column you want to move.
    2. Press Ctrl + Spacebar to select the entire column.
    3. Press Ctrl + X to cut it.
    4. Use the arrow keys to move to a cell in the destination column.
    5. Press Ctrl + + (the Control key and the plus key). This is the shortcut for "Insert Cut Cells" and will insert your column.
  • Check Your Charts: If your spreadsheet has charts that pull data from the columns you are moving, take a moment to check them afterwards. Excel is generally excellent at updating the chart's data source automatically, but it's always worth a quick look to ensure everything is still being displayed correctly.
  • Moving Columns in a Table: If your data is formatted as an official Excel Table (created via Insert > Table), the moving process is the same. Select the column by clicking just above the table header, and then use the Shift-Drag method. The table formatting and functionality will move with the column.

Step-by-Step Instructions

Document what changed

Save the final settings, decisions, or checks so the same process is easier to repeat later.

Tip: Keep the step simple and verify the result before continuing.

How To Move Columns In Excel FAQ

How do I move a column to the very beginning or end of my sheet?
Use the Shift-Drag method. To move a column to the very beginning, drag it and drop it when the green insertion line is just before Column A. To move it to the end, drag it past the last column of your data; the green insertion line will appear after it.
Does moving columns work the same way in Google Sheets?
Yes, the core mechanics are very similar. In Google Sheets, you can also select a column header and then simply drag and drop it. Google Sheets automatically inserts the column by default, making it less risky than Excel's standard drag-and-drop.
Can I move a column from one sheet to another?
Yes, but you cannot drag and drop between sheets. For this, you must use the Cut and Paste method. Select and Cut the column (Ctrl+X) from your source sheet. Click on the tab for the destination sheet, select the column header where you want it to go, right-click, and choose Insert Cut Cells.
Will moving a column mess up my filters or sorting?
No, if you move the entire column, any filters or sorting applied to that column will move with it. Excel treats the column as a single unit, including its properties. After the move, your data will remain sorted or filtered as it was before.

Quick Reference

Situation Use this Why
Safely inserting a column between two others Shift + Drag and Drop Inserts the column without overwriting any data. It's the best and safest default method for everyday use.
Moving a column a long way across a large sheet Cut (Ctrl+X) and Insert Cut Cells More precise and easier than trying to drag over many screens. Avoids scrolling mistakes.
Moving several columns that aren't next to each other Ctrl + Click to select, then Shift-Drag Allows you to group and move non-adjacent columns as a single block in one efficient action.
Moving a column into an empty area (or replacing junk data) Standard Drag and Drop The fastest physical action, but highly destructive. Only use when you are certain you want to overwrite the destination.

Final Checklist for Moving Columns

  • Backup Saved: Did you save a copy of your workbook before starting, especially if it's an important file?
  • Correct Method Chosen: Have you decided to use the safe Shift-Drag or the precise Cut/Insert method to prevent data loss?
  • Full Column Selected: Is the entire column highlighted from top to bottom, achieved by clicking the column's header letter?
  • Destination Confirmed: Do you know exactly where the column is going, and have you visualised the green insertion line to confirm its new position?
  • Formulas Verified: If your sheet contains formulas that reference the moved column, have you briefly checked them to ensure they updated correctly and are not showing errors?
  • Charts and Pivots Checked: If the moved column was part of a chart or pivot table, did you glance at them to confirm they still look correct?

Keep reading

More from the editorial desk.