• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Delete Table Columns in Excel

October 20, 2021 by Andrew Childress
How to do a contingency table in Excel

Data tables help you organize and group together a data set in Excel. One key feature you need to know is how to delete table columns in Excel. Here's how.

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. 

Delete table columns Excel

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.

Delete multiple columns

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.

Category: Excel FunctionsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post: « Taxonomy Excel How to Create a Taxonomy in Excel
Next Post: Coalesce Function in Excel How to make a coalesce function in Excel »

Sidebar

Recent Posts

  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel
  • EXACT in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

  • Facebook
  • Twitter
  • Instagram
  • LinkedIn
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2022 · Excelypedia · All Rights Reserved

Back to top