How to Move Cells in Microsoft Excel - WindowsTips.net - Windows Tips and Tricks with Geek

Sunday, November 21, 2021

How to Move Cells in Microsoft Excel

 Microsoft Excel logo on a green background

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

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.

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.

No comments:

Post a Comment