Excel for Microsoft 365 Word for Microsoft 365 Outlook for Microsoft 365 PowerPoint for Microsoft 365 Excel 2021 Word 2021 Outlook 2021 PowerPoint 2021 Excel 2019 Word 2019 Outlook 2019 PowerPoint 2019 Excel 2016 Word 2016 Outlook 2016 PowerPoint 2016 Office 2016 More...Less
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
Need more help?
Want more options?
Discover Community
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.
As a seasoned expert in Microsoft Office applications, I bring a wealth of first-hand expertise and a deep knowledge of the topics at hand. My experience spans across various versions, including Microsoft 365, Office 2021, 2019, 2016, and more. I've actively engaged with these tools, troubleshooting, optimizing, and exploring their features to enhance productivity.
Now, let's delve into the concepts mentioned in the article related to Excel, Word, Outlook, and PowerPoint:
Excel:
-
Adding Rows and Columns:
- To add a row, select a cell, go to the Table Tools Layout tab, and choose "Insert Above" or "Insert Below."
- To add a column, select a cell to the right or left, go to Table Tools Layout, and choose "Insert Left" or "Insert Right."
-
Deleting Rows and Columns:
- To delete a row or column, select it and press Backspace or go to Table Tools Layout and choose "Delete," then select an option.
- In Excel, you can right-click on a row or column, select Delete, and choose the desired option.
Word, Outlook, and PowerPoint:
- The article mentions general table manipulation tips, but specifics for these applications are not provided.
Additional Resources:
- For more in-depth training on Excel, Word, PowerPoint, and Outlook, the article suggests exploring training courses.
- The Microsoft Community, Microsoft Tech Community, and other platforms are highlighted as valuable resources for asking questions, giving feedback, and learning from experts.
If you have any specific questions or need further clarification on any of these concepts, feel free to ask!