Video add and delete table rows and columns

Try it!

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?

Insert or delete rows or columns

Insert or delete cells, rows, and columns

Add or delete table rows and columns

Excel training

Word training

Excel training

PowerPoint training

Outlook training