How to Add or Delete Columns and Rows in a Table in Microsoft Excel

Join 425,000 subscribers and get a daily digest of news, geek trivia, and our feature articles.
By submitting your email, you agree to the Terms of Use and Privacy Policy.
With her B.S. in Information Technology, Sandy worked for many years in the IT industry as a Project Manager, Department Manager, and PMO Lead. She learned how technology can enrich both professional and personal lives by using the right tools. And, she has shared those suggestions and how-tos on many websites over time. With thousands of articles under her belt, Sandy strives to help others use technology to their advantage. Read more…
Microsoft Excel Logo
When you create a table in Microsoft Excel, you might need to adjust its size later. If you need to add or remove columns or rows in a table after you create it, you have several ways to do both.
If you want to work with both tables and columns, whether adding or deleting them, the handiest way is with the Resize Table feature.
Select any cell within the table. Go to the Table Design tab that appears and click “Resize Table” on the left side of the ribbon.
On the Table Design tab, click Resize Table
In the pop-up window, you can use the cell range text box to adjust the cell references. If you prefer, you can drag through the columns and rows while the window is open. Click “OK” when you have the table sized as you want it.
Resize your table
If you simply want to add more columns or rows, there are a few ways to do it. You can use whichever method is most convenient or comfortable for you.
To add another column, type your data in the cell to the right of the last column. To add another row, type data in the cell below the last row. Hit Enter or Return.
Type data to add a column or row
This automatically adds a column or row that’s included in the table.
Like typing into the cell, you can also paste data. So if you have data from another location on your clipboard, head to the cell to the right of the last column or below the last row and paste it. You can use “Paste” on the Home tab or right-click and select “Paste.”
Paste data to add a column or row
This also adds the number of columns or rows of data, which are then part of the table.
Whether you like to right-click or use the buttons in the ribbon, there’s an Insert option that makes adding columns or rows easy. And like many other tasks, there are a few different ways to use Insert.
Right-click and pick Insert
Click Insert on the Home tab
Right-click, pick Insert and choose column or row
Like adding columns or rows to a table in Microsoft Excel, deleting them is just as simple. And as you’ve probably already guessed, there’s more than one way to do it! Here, you’ll simply use the Delete feature.
As you might have noticed when using the Insert feature above, there’s also a Delete option nearby. So, use one of these actions to delete a column or row.
Right-click and pick Delete
Click Delete on the Home tab
Right-click, pick Delete and choose column or row
If you’re interested in getting help with columns and rows in Excel outside of tables, take a look at how to freeze and unfreeze columns and rows or how to convert a row to a column.
RSS Feed
The Best Free Tech Newsletter Anywhere
By submitting your email, you agree to the Terms of Use and Privacy Policy.


Digital Strategist Chris Hood

Leave a Reply

Your email address will not be published. Required fields are marked *

© 2021 SHAQ HAX - Proudly powered by theme Octo