Related topics
×
Rows & columns
Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
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. 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:
    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

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×