Add and format tables and charts

Add and delete table rows and columns

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

When your table needs more data, add rows and columns, or remove them to get rid of empty cells.

Add a row

  1. Select a cell.

  2. Select the Table Tools Layout tab > Insert Above or Insert Below.

Add a column

  1. Select a cell to the right or left of where you want the new column to appear.

  2. Select the Table Tools Layout tab > Insert Left or Insert Right.

Delete a row or column

  1. Select a row or column that you want to delete.

  2. Press Backspace, or select the Table Tools Layout tab >Delete, and then select an option.

    Note: In Excel, select a row or column that you want to delete, right-click and select Delete , and choose the option you want. Or select a cell, and then select Home > Insert or Home > Delete, and then choose an option.

Want more?

Add or delete table rows and columns

Insert or delete cells, rows, and columns

Video: Insert or delete rows or columns

Add columns and rows to a table

Excel training

When working with tables, you might need to add or delete rows and columns.

To insert a row, select a cell.

Select the Table Tools Layout tab,

and then select Insert Above orInsert Below.

Add columns the same way.

Select a cell, and then select Insert Left or Insert Right.

To delete a row or column, select the row or column and press Backspace.

Or, select a cell in the row or column,

nd then select an option from the Delete drop-down.

In Excel, select a row or column, right-click, and select Delete.

Or, select a cell, and on the Home tab, select Insert or Delete, and then select an option.

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.

×