• 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 Sheet Columns in Excel

November 8, 2021 by Andrew Childress
Delete sheet columns in Excel

When you work in Excel, you may find yourself with columns that you no longer need. Let’s learn how to delete sheet columns in Microsoft Excel.

When you work in Excel, you may find yourself with columns that you no longer need. You might want to take these data-filled columns and shift other data back into place. Fortunately, Excel offers a great way to do exactly that. Let’s learn how to delete sheet columns in Microsoft Excel.

How to Delete Sheet Columns in Excel

When you build layouts in Excel spreadsheets, data is often placed across multiple columns. But imagine if you need to remove some of these columns. Simply deleting the data from the columns will leave them blank, but data in other columns won’t move. Consider an example. If you have data in columns A, B, and C, you could delete the values from column B. But column C will remain in position, leaving a blank column in the middle of your data.

This is where the Delete Sheet Columns feature comes in. By using Delete Sheet Columns, you can remove column B entirely. Column C will shift one position to the left, becoming the new column B. This eliminates unwanted data in Excel, while preventing blank columns from sitting in the midst of your sheets.

Delete sheet columns Excel

To use Delete Sheet Columns, click on the column header that you want to delete. Or, you can multi-select by holding down Command (Control on Windows).

Then, with columns selected, go to Excel’s Home tab on the ribbon. The ribbon is the series of menus across the top of the screen.

Delete sheet columns in Excel

On the right side of the Home tab, you’ll see the Delete dropdown. Choose it, then click Delete Sheet Columns.

How to delete sheet columns in Excel

The selected column or columns will disappear. Columns to their right will shift into place, filling the void left by the deleted columns.

As you can see, it’s easy to use Delete Sheet Columns to seamlessly remove unwanted data in Microsoft Excel.

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

About Andrew Childress

Previous Post:How to fill Excel cellsFill in Excel
Next Post:Rotate Text Up in ExcelHow to rotate text up in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows 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
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top