How to Move Columns in Excel: Rearrange with 2 Easy Methods

PDF download Download Article
An easy guide to rearranging columns in your Excel spreadsheet
PDF download Download Article

Need to quickly move an entire column in Microsoft Excel? Luckily, it’s a pretty easy procedure. You can select, click and drag columns with your mouse. Or, use the cut and paste commands. This wikiHow article will show you how to select and move columns in Excel on Windows or Mac.

Things You Should Know

  • On Windows or Mac, select the column, then click and drag the border of the selection to a new location.
  • On Windows, select the column, then press Ctrl + x to cut the column. Right-click the column to the right of the new destination and select “Insert Cut Cells.”
  • To move multiple adjacent columns, press Ctrl (Windows) or Cmd (macOS). Then, click the column letters above the columns you want to move.
Method 1
Method 1 of 2:

Using the Mouse

PDF download Download Article
  1. This selects the column. In this method, you’ll use the mouse to drag the column to a new position. This works on Windows and macOS.
    • This method only works for a single column. To move multiple columns, use cut and paste commands (see next method).
    • Moving columns is a great way to set up your spreadsheet for a Vlookup or Sum formula.
    • For general spreadsheet tips, check out our guide on making a spreadsheet in Excel .
  2. The cursor will turn into four arrows (Windows) or a hand (macOS). [1]
    • The cursor will turn into a hand in the web app version of Excel.
    Advertisement
  3. Click and drag the selected column to the location where you want to move it, and then release the mouse button. This will cut and replace the column.
    • If you want to copy and replace columns instead of just moving them, hold down Ctrl (Windows) or ⌥ Option (macOS) while dragging and dropping.
    • Holding ⇧ Shift will cut and insert the columns.
    • Holding Ctrl + ⇧ Shift will copy and insert the columns.
    4. Advertisement
Method 2
Method 2 of 2:

Using Commands

PDF download Download Article
  1. This selects the column. The commands method only works on the Windows version of Excel.
    • To move more than one (adjacent) column at the same time, hold down Ctrl as you click each column letter.
    • Formatting your spreadsheet can significantly improve your Excel experience.
  2. This “cuts” the data in the column, which really just selects it and adds it to the clipboard.
    • The column data will remain in its place until you paste it into its new location.
    • You can also cut the column by clicking the scissors icon on the Home tab. It’s in the “Clipboard” section near the top-left corner of the app.
    • If you cut the wrong column, press Esc to return the data to its original location.
  3. A drop-down menu will open.
    • When you insert your copied data, it'll be to the left of the column you right-click.
  4. Excel will insert the cut column to the left of the one on which you right-clicked.
    • If you want to undo the pasted column, press Ctrl + Z .
    • Alternatively, you can click the drop-down icon next to the Insert button on the Home toolbar at the top, and select Insert Cut Cells or Insert Cells here. This will insert and move your data the same way.
    5. Advertisement

Expert Q&A

Search
Add New Question
  • Question
    columns a and b suddenly disappeared from excel. how to retrieve?
    Kyle Smith
    wikiHow Technology Writer
    Kyle Smith is a wikiHow Technology Writer, learning and sharing information about the latest technology. He has presented his research at multiple engineering conferences and is the writer and editor of hundreds of online electronics repair guides. Kyle received a BS in Industrial Engineering from Cal Poly, San Luis Obispo.
    Kyle Smith
    wikiHow Technology Writer
    Expert Answer
    The columns might be hidden! Try selecting the adjacent column (c) and right-clicking that column. Select Unhide from the pop-up menu.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 1 Helpful 0
  • Question
    see column B and K at the same time
    Kyle Smith
    wikiHow Technology Writer
    Kyle Smith is a wikiHow Technology Writer, learning and sharing information about the latest technology. He has presented his research at multiple engineering conferences and is the writer and editor of hundreds of online electronics repair guides. Kyle received a BS in Industrial Engineering from Cal Poly, San Luis Obispo.
    Kyle Smith
    wikiHow Technology Writer
    Expert Answer
    There are a few ways to go about this! You can freeze columns A and B to keep them on the screen at all times. Alternatively, hide some or all columns between B and K so that they're closer together. You could also move column K next to B using this guide's method above.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 1 Helpful 0
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Video

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      How to
      Merge Cells in Microsoft Excel: A Quick Guide
      How to
      Unprotect an Excel Sheet
      How to
      Unhide All Rows and Columns in Microsoft Excel
      How to
      Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Create a Graph in Excel
      How to
      Show Hidden Columns in Microsoft Excel & Unhide Column A
      How to
      Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      3 Easy Ways to Freeze Panes to Lock Columns or Rows in Excel
      How to
      Change from Lowercase to Uppercase in Microsoft Excel
      How to
      Make a Spreadsheet in Excel
      New to Excel? Here's Super Easy Tricks to Get You Started
      How to
      Link Sheets in Excel
      Advertisement

      References

      1. ↑ https://support.microsoft.com/en-us/office/move-or-copy-cells-rows-and-columns-3ebbcafd-8566-42d8-8023-a2ec62746cfc#ID0EBD=Windows

      About This Article

      Article Summary X

      1. Click the column letter.
      2. Hover the mouse over the selection's edge until the cursor changes.
      3. Click and drag the column to a different location.

      Did this summary help you?
      In other languages
      Thanks to all authors for creating a page that has been read 220,424 times.

      Is this article up to date?

      Advertisement