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.