Insert cells in a sheet / Shift the cells to the right or down.

To shift cells to the right or down:

1. Select the cells to be shifted.

2. Click Insert > Cell > Shift Cells Right or Shift Cells Down to move the cells to the right or down respectively.

• Related Articles

• Shift cells to the left or above

  To shift cells to the left or above: 1. Select the cells to be shifted. 2. Click Edit > Delete > Shift Cells Left or Shift Cells Up to move the cells to the left or up respectively.

• Insert a note in a sheet

  To insert button: 1. Select the cell you want the note to be in. 2. Click Insert > Note.    The notes you make are hidden by default and is revealed only when the cell with the note is hovered upon. If you want to show all the notes by default, go to ...

• Lock cells

  To lock a range of cells, Select the particular cell or range of cells that you wish to lock. Select Data > Lock> Lock Cells. You can also right click on the selected range and click Lock Cells. The Lock Cells dialog box appears. Choose the ...

• Remove or clear the formatting from cells

  To clear the formatting of a cell: Select the cell you want to clear the formatting of. Click on the Clear icon  in the tool bar. You can then choose to clear only the formats from the cell. Alternatively, right click on the cell you want to clear ...

• Lock a sheet

  You can also lock a particular sheet to be made inaccessible to edit for other collaborators. To lock a sheet Click Data > Lock> Lock Sheet. Lock the sheet to those collaborators for whom you wish to lock the cells. The sheet stays locked to newly ...