Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
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

Excel training

Word training

Excel training

PowerPoint training

Outlook training

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!