Data tables help you organize and group together a data set in Excel. Once you have your data in a table, you unlock some neat features like easy subtotals and easy-to-write formulas.
Sometimes, you’ll need to modify the data inside those tables. One key feature you need to know is how to delete table columns in Excel. Let’s learn how.
How to Delete Table Columns in Excel
Let’s say that you’re working in a data table and suddenly decide that a column is no longer needed. The best way to remove that column is to simply right-click inside the desired column and choose the Delete menu. Then, choose Table Columns.
This step removes the active table column, including the header column. All of the data will slide to the new shape of the table, adapting to your selected column structure.
Keep in mind that if you simply highlight the column and press Delete on your keyboard, you’ll remove the data inside – but the column is still in tact. You’ll see blanks for each cell, but the column is left unchanged. Decide first if you want to remove the column or the data, then use the appropriate option.
How to Delete Multiple Table Columns in Excel
What if you decide you need to remove multiple table columns? Don’t worry, that’s just as easy! In this case, just highlight cells in at least two adjacent columns that you wish to delete. Then, repeat the same steps: right-click and choose Delete > Table Columns. All selected columns are deleted, and the data shifts accordingly.
Of course you can always Undo any changes you accidentally make.
Remember: Excel spreadsheets are dynamic and constantly shifting. Make sure you remember this skill so that your tables evolve to fit your data needs.