Microsoft Excel logo on a green background

Need to rearrange data in your spreadsheet? You can move cells in Microsoft Excel to different spots in the same sheet or to another spreadsheet or workbook. Use one of these methods to take your cell contents wherever you like.

About Moving Cells in Excel

When you move a cell or cell range in Excel, you are moving all of the cell’s contents as-is. So whether the cell contains a word, value, formula, or function, it will be moved.

In addition, if you have comments attached to a cell or special formatting, those items will move with the cells.

Move Cells in Excel Using Drag and Drop

If you want to move a cell or group of cells to another location in your spreadsheet, drag and drop is the simplest method.

Select the cell and place your cursor over an edge of the cell. You’ll see a four-sided arrow appear.

Select a cell and click the arrow

Advertisement

Then just click and drag the cell where you want it in your sheet. As you drag, you’ll notice a green outline of the cell and the new cell reference (location) display. Simply release when the cell lands in its new spot.

Drag a cell to its new spot

You can use the same drag-and-drop action to move a group of cells or even a table. Select the cell range you want to move and place your cursor on the edge of the group to display the four-sided arrow.

Select the cells and click the arrow

Click the arrow and like with a single cell, you’ll see an outline of the group as you drag along with the new cell range. Release when the cells are in their new locations.

Drag the cells to their new spots

If you’re using Excel on Mac, you’ll see a small hand instead of a four-sided arrow when dragging a cell or cell range. But the rest of the drag and drop method works the same as it does on Windows.

Select a cell and click the hand on Mac

When you move a cell or cell range and it overlaps with cells already containing data, you’ll receive an alert message.

Moving overlapping cells

The message explains that the destination cells already contain data and asks if you want to replace that data with the cells you’re moving. Click “OK” to replace the data or “Cancel” to stop the move.

Moving overlapping cells alert

Move Cells in Excel Using Cut and Paste

If you want to move a cell or group of cells to a different spreadsheet or workbook, you can use the cut and paste method.

Advertisement

Select the cell or cell range and then either right-click and pick “Cut” or go to the Home tab and click “Cut” in the Clipboard section of the ribbon.

Right-click and pick Cut

Go to a cell in the new sheet or book where you want to paste the cell(s) you just Cut. Either right-click and pick “Paste” or go to the Home tab and click “Paste” in the Clipboard section of the ribbon.

Right-click and pick Paste

For a quick way to cut and paste cells, you can also use keyboard shortcuts. On Windows, press Ctrl+X to Cut and Ctrl+V to Paste. On Mac, use Command+X to Cut and Command+V to Paste.

Rearranging data in your Excel sheets doesn’t have to be time-consuming and both of these methods allow you to move cells easily. You can also move rows and columns just as easily. And if it’s entire sheets you need to move, learn how to move a sheet to another workbook in Excel.

RELATED: All the Best Microsoft Excel Keyboard Shortcuts

Profile Photo for Sandy Writtenhouse Sandy Writtenhouse
With her B.S. in Information Technology, Sandy worked for many years in the IT industry as a Project Manager, Department Manager, and PMO Lead. She learned how technology can enrich both professional and personal lives by using the right tools. And, she has shared those suggestions and how-tos on many websites over time. With thousands of articles under her belt, Sandy strives to help others use technology to their advantage.
Read Full Bio ยป

The above article may contain affiliate links, which help support How-To Geek.