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.

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

Add columns and rows to a table

Excel training

Word training

Excel training

PowerPoint training

Outlook training

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.

×