Insert or delete cells, rows, and columns

Insert or delete a column

1. To insert a column, select the column, select Home > Insert >  Insert Sheet Columns.

2. To delete a column, select the column, select Home > Insert > Delete Sheet Columns.

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

Insert or delete a row

1. To insert a row, select the row, select Home > Insert > Insert Sheet Rows.

2. To delete a row, select the row, select Home > Insert > Delete Sheet Rows.

   Or, right-click the selected row, 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 row, column or cell to insert.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

Related Guides

• Split text into different columns with the Convert Text to Columns Wizard
• Import or export text (.txt or .csv) files
• Find or replace text and numbers on a worksheet
• Collaborate on Word documents with real-time co-authoring
• OneDrive basics