Cutting or Moving the Contents Cells

Education is not limited to just classrooms. It can be gained anytime, anywhere... - Ravi Ranjan (M.Tech-NIT)

Cutting or Moving the Contents of Cells

Introduction

In Lesson 2, we saw how to move a column or a group of columns from one location to another. In Lesson 3, we saw how to move a row from one section of the worksheet up or down. Sometimes, instead of moving the whole column or the whole row, you may want to move only one particular cell or a group of cells. To move the content of a cell to the clipboard and paste it somewhere:

  • Right-click the cell and click Cut. To paste the value of the cell somewhere, click the target cell and press Enter, or right-click the target cell and click Paste
  • Click the cell. On the Ribbon, click Home. In the Clipboard section, click Cut. Click the target cell. To paste the cell, in the Clipboard section of the Ribbon, click Paste

When you move a column or a row, it gets removed from the previous location and carries its cells to the new location. An alternative is to move only a particular group of cells. To move the contents of a group of cells to the clipboard, select the cells:

  • Right-click the group and click Cut. To paste the values of the cells somewhere, click a target cell and press Enter, or right-click a target cell and click Paste
  • On the Ribbon, click Home. In the Clipboard section, click Cut. Click the target cell. To paste the cell, in the Clipboard section of the Ribbon, click Paste

Practical Learning: Cutting Cells Contents

  1. Right-click Cell F18 and click Cut. One more item gets copied to the Clipboard
  2. Click Cell D12
    On the Clipboard window, click E-Mail

Moving Cells

To move a cell, you ask Microsoft Excel to remove its content from that location to a new location of your choice. When you do this, only the content of the cell moves, leaving the previous location empty.

To move a cell, first click it to give it focus. Position the mouse on one of its borders the mouse cursor changes into a cross:

Moving a Cell

Click and hold your mouse down. Drag up, down, left or right to the target cell of your choice. A rectangular box that is the same size as the cell would guide you and assume the position of the mouse where the mouse is currently over:

When the cell is positioned where you want, release the mouse. If you land on a cell that contains something already and that cell is allowed to receive a value (some cells can be "locked" so they cannot receive a value), you would receive a warning message box asking you to confirm that you really want to replace the value in the target cell:

Replacing the value in the target cell

If you click OK, the content of the target value would be replaced with that of the cell that was moved:

To move more than once cell, first select the cells in a range (they most be selected as a range). Position the mouse on the border of the selection until the mouse cursor turns into a cross. Click the drag in the direction of your choice. A guiding box that is the same size as the group would guide you. When you get to the new location, release the mouse.

Practical Learning: Moving a Cell

  1. Click Cell D12 to give it focus
  2. Position the mouse on one of its border until the mouse appears as a cross. Click and drag to Cell F12