Tip: Video not in your language? Try selecting Closed Captions .
When your table needs more data, add rows and columns, or remove them to get rid of empty cells.
Add a row
Select a cell.
Select the Table Tools Layout tab > Insert Above or Insert Below.
Add a column
Select a cell to the right or left of where you want the new column to appear.
Select the Table Tools Layout tab > Insert Left or Insert Right.
Delete a row or column
Select a row or column that you want to delete.
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.
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.