Insert or delete cells, rows, and columns Insert or delete a column Select any cell within the column, then go to Home > Insert > Insert Sheet Columns or Delete Sheet Columns. Alternatively, right-click the top of the column, and then select Insert or Delete. Insert or delete a row Select any cell within the row, then go to Home > Insert > Insert Sheet Rows or Delete Sheet Rows. Alternatively, right-click the row number, and then select Insert or Delete. Insert a cell 1. Select one or more cells. Right-click and select Insert.2. From the Insert box, select a cell to insert.