Rows & columns

Insert or delete rows or columns

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Try it!

Small changes in the layout of your worksheet can give you big improvements in readability. Insert and delete rows, columns, and cells to organize your worksheet.

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.
    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. SelectHome > 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:
    Insert box

    • 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

Discover more courses like this at LinkedIn Learning

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×