Insert or delete rows or columns

Insert a column

1. Select the letter at the top of a column to select the column.

2. Select Home > Insert > Insert Sheet Columns
   Or, right-click the top of the column, and then select Insert.

   Note: Excels inserts a new column to the left.

Delete a column

1. Select the column.

2. Select Home > Delete > Delete Sheet Columns.

   Or, right-click the top of the column, and then select Delete.

Insert a row

1. Select the row number to select a row.

2. Select Home > Insert > Insert Sheet Rows.
   
   Or, right-click the selected row, and then select Insert.

   Note: A new row is inserted above the selected row.

Delete a row

1. Select the row.

2. Select Home > Delete > Delete Sheet Rows.
   Or, right-click the selected row, and then select Delete.

Insert a cell

1. Select a cell or a cell range.

2. Right-click the selected cells, and then select Insert.

3. In the Insert box, select an option:
   

   • Shift cells right – shifts cells right to make space for the new cell(s).

   • Shift cells down – shifts cells down to make space for the new cell(s).

   • Entire row – inserts a new row.

   • Entire column – inserts a new column.

4. Select OK.

Want more?

Insert or delete cells, rows, and columns