Home » Manage data » Move a cell with the mouse in Excel

Move a cell with the mouse in Excel

Reading time: 2 minutes
Last Updated on 20/05/2023 by Frédéric LE GUEN

How to move a cell with the mouse in Excel? It's very easy and much more efficient than doing a cut and paste.

Move a cell with the mouse in Excel

To move a cell with the mouse in Excel, you just have to:

  1. Select the cell you want to move
  2. Put the cursor of the mouse on one of the borders of the cell
  3. Drag & Drop the cell
Move one cell with the mouse
  • As you notice, the content, the font size, the font color, the background color, and the cell's border have been moved
  • The height and the width of the cell don't have been repro.

Move a cell with a formula

If you have a formula in your cell, what happens with the references?

Move cell with formula with the mouse

When you move a cell with a formula, the references are kept. It's not like a copy-paste where the references change according to the direction of the copy

Move a range of cells with the mouse

With the same technique, you can move a range of cells from one location to another one in the same worksheet.

  1. Select the range of cells you want to move
  2. Put the cursor of the mouse on one of the borders of the selection
  3. Drag & Drop the selection
Move a range of cells with the mouse

Here again, you move the content of the cells and the format.

Leave a Reply

Your email address will not be published. Required fields are marked *

Move a cell with the mouse in Excel

Reading time: 2 minutes
Last Updated on 20/05/2023 by Frédéric LE GUEN

How to move a cell with the mouse in Excel? It's very easy and much more efficient than doing a cut and paste.

Move a cell with the mouse in Excel

To move a cell with the mouse in Excel, you just have to:

  1. Select the cell you want to move
  2. Put the cursor of the mouse on one of the borders of the cell
  3. Drag & Drop the cell
Move one cell with the mouse
  • As you notice, the content, the font size, the font color, the background color, and the cell's border have been moved
  • The height and the width of the cell don't have been repro.

Move a cell with a formula

If you have a formula in your cell, what happens with the references?

Move cell with formula with the mouse

When you move a cell with a formula, the references are kept. It's not like a copy-paste where the references change according to the direction of the copy

Move a range of cells with the mouse

With the same technique, you can move a range of cells from one location to another one in the same worksheet.

  1. Select the range of cells you want to move
  2. Put the cursor of the mouse on one of the borders of the selection
  3. Drag & Drop the selection
Move a range of cells with the mouse

Here again, you move the content of the cells and the format.

Leave a Reply

Your email address will not be published. Required fields are marked *