Move cells with the mouse in Excel (Easy Guide)

Move cells with the mouse in Excel (Easy Guide)
Last Updated on 30/10/2023
Reading time: 2 minutes

How to move cells 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 cells you want to move

    It could be one or more than one cell. The technique is the same

  2. Put the cursor of the mouse on one of the borders of the cell

    The cursor will be a cross with 4 arrows

  3. Drag & Drop the cell

    Hold the button of the mouse when you drag and 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.

Related Articles

Leave a Reply

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

Move cells with the mouse in Excel (Easy Guide)

Reading time: 2 minutes
Last Updated on 30/10/2023

How to move cells 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 cells you want to move

    It could be one or more than one cell. The technique is the same

  2. Put the cursor of the mouse on one of the borders of the cell

    The cursor will be a cross with 4 arrows

  3. Drag & Drop the cell

    Hold the button of the mouse when you drag and 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.

Related Articles

Leave a Reply

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