Inserting or deleting rows, and columns

Insert or delete a column


  1. Choose any cell within the column, then go to Home > Insert > Insert Sheet Columns or Delete Sheet Columns.
  2. Another way is to right-click the top of the column, and then press Insert or Delete.


Insert or delete a row


  1. Click any cell within the row, then go to Home > Insert > Insert Sheet Rows or Delete Sheet Rows.
  2. Otherwise, right-click the row number, and then choose Insert or Delete.


Formatting Options

When you choose a row or column with pre-existing formatting, such formatting will be transposed to a new row or column that you add.

If the Insert Option button doesn’t appear, then go to FileOptionsAdvanced in the Cut, copy and paste category, and then check the Show Insert Options buttons choice.

%d bloggers like this: