Try it!
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.
Want more?
Insert or delete rows or columns
Insert or delete cells, rows, and columns
