Insert and Move Cells

While working on a spreadsheet, cells themselves may need to be inserted, moved, or deleted. When cells are changed and moved, the existing cells shift, along with their content, to adjust for the changes to adjacent cells.

Insert Cells

First, you'll want to select the cells next to where you want the new ones.

  1. Select the cell or cell range where you want to insert the new cells.
  2. Click Insert on the menu bar.
  3. Select either Cells and shift down or Cells and shift right.
    Insert and Move Cells

Blank cells are inserted and the existing ones move according to your selection.

Insert Rows or Columns

  1. Select the column or row next to where you want to insert new cells.
  2. Click Insert on the menu bar.
  3. Select one of the options:
    • Column left / Row above
    • Column right / Row below
    Insert and Move Cells

The row or column is inserted. Existing rows are shifted downward, while existing columns are shifted to the right.

Move Cells

Now let's check out how to move cells to a different area of a spreadsheet.

  1. Select the cell or cell range you want to move.
  2. Move the mouse pointer over the outline of the selected cells.
  3. Click and drag the cells to the new location.
    Insert and Move Cells

The cells are moved to the destination you specified.

Google Sheets Quick Reference

FREE Quick Reference

Click to Download

Free to distribute with our compliments; we hope you will consider our paid training.