• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Move Cells in Excel

May 23, 2021 by Andrew Childress
Move cells Excel

Often, you’ll find yourself needing to move cells in a spreadsheet. This is very easy to do. Here's how to move cells in Microsoft Excel.

Often, you’ll find yourself needing to move cells in a spreadsheet. Fortunately, this is very easy to do. It only takes a few clicks. Let’s learn how to move cells in Microsoft Excel.

How to Move Cells in Excel

Consider a list of data containing several cells. You have multiple columns, and you want to move a pair of cells between columns. You might think that you need to re-type the data inside, but there’s no need. Excel makes moving cells a breeze.

To get started, begin by selecting the cells that you want to move. In this example, that’s cells B7 and B8. To select them, simply click and drag your cursor across the two cells.

Move cells Excel

Now, you need to figure out where you want to move the cells to. In order to keep the columns the same length, the empty cells C5 and C6 are a good option.

To make the move, hover your mouse over the green border that appears around the cells you have selected. You’ll see the hand icon appear.

Then, click and drag to begin moving the two cells. In the lower right corner of the selection, you’ll see Excel start to display a cell range. This is telling you where the two cells would be placed if you release your mouse cursor.

Move cells in Excel

Move up and to the right, until you see C5:C6 appear in the preview. Release your selection, and Excel will drop it into place.

How to move cells in Excel

Note: Any cell contents that previously existed will be deleted, although Excel will display an Alert message prior to replacing any content. Keep this in mind before you start moving cells around your spreadsheets.

As you can see, Excel makes it easy to move cells. This is a quick way to change up the layout and format of any worksheet. Try it today.

Category: Excel TutorialsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Freeze columns ExcelFreeze Columns in Excel
Next Post:Today Function in ExcelToday function Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top