Insert or delete a column
- Choose any cell within the column, then go to Home > Insert > Insert Sheet Columns or Delete Sheet Columns.
- Another way is to right-click the top of the column, and then press Insert or Delete.
Insert or delete a row
- Click any cell within the row, then go to Home > Insert > Insert Sheet Rows or Delete Sheet Rows.
- Otherwise, right-click the row number, and then choose Insert or Delete.
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 File > Options > Advanced in the Cut, copy and paste category, and then check the Show Insert Options buttons choice.