How to Delete Columns in Excel: Every Method Explained

Deleting columns in Excel sounds simple — and often it is. But depending on how your spreadsheet is structured, which version of Excel you're running, and whether you're working with raw data or a formatted table, the right approach can vary more than you'd expect. Here's a complete breakdown of every reliable method, plus the key distinctions that trip people up.

The Basic Method: Right-Click to Delete

The most straightforward way to delete a column is through the right-click context menu:

Click the column header (the letter at the top — A, B, C, etc.) to select the entire column
Right-click on the highlighted header
Select "Delete" from the menu

The column disappears and everything to the right shifts left automatically. If you need to delete multiple adjacent columns, click the first column header, hold Shift, click the last column header, then right-click and delete. For non-adjacent columns, hold Ctrl (or Cmd on Mac) while clicking each column header, then right-click and delete all at once.

⚠️ This deletes the entire column — not just its contents. Every cell in that column is removed and the surrounding columns close the gap.

Deleting Column Contents vs. Deleting the Column Itself

This is the distinction that catches many users off guard.

Action	What Happens	Shortcut
Delete key (after selecting column)	Clears cell contents only	`Delete`
Right-click → Delete	Removes column entirely, shifts data	Context menu
Backspace	Clears active cell only	`Backspace`
Clear Contents	Removes values, keeps formatting	Right-click menu

If you select a column and press Delete on your keyboard, you're erasing the data inside those cells — not the column itself. The empty column remains in place. This matters when your layout depends on column positioning or when you're cleaning data without disrupting the structure.

Keyboard Shortcuts for Faster Column Deletion 🎯

If you're working through large spreadsheets, using the mouse for every deletion gets slow. Here are the fastest keyboard-based approaches:

On Windows:

Select the column header → Ctrl + - (minus key) → confirms deletion immediately

On Mac:

Select the column header → Ctrl + - or Command + - depending on your Excel version

Via the ribbon:

Select any cell in the column → Home tab → Cells group → Delete dropdown → "Delete Sheet Columns"

The ribbon method is useful when you're already navigating by keyboard and don't want to reach for the mouse.

Deleting Columns Inside Excel Tables (Formatted Tables)

If your data is formatted as an Excel Table (inserted via Insert → Table), column deletion behaves slightly differently. Deleting a table column only removes it from within the table structure — it won't affect data outside the table in the same column.

You'll also notice the right-click menu shows "Delete Table Columns" rather than just "Delete," which signals you're operating within a structured range. This is intentional — Excel protects the integrity of the table's data model.

If you want to delete the entire worksheet column (including anything above or below the table in that column), you'd still select the column header and delete from there.

Using Find & Select to Delete Columns Based on Content

Sometimes you don't know exactly which columns to remove — you need to find and delete columns that are blank, contain specific values, or meet certain criteria.

To delete all blank columns efficiently:

Select your data range
Press Ctrl + G → Special → select Blanks
Right-click any highlighted cell → Delete → choose Entire Column

This works well for cleaning up imported data or spreadsheets where blank columns appear irregularly across a large range.

Undo Is Your Safety Net — But It Has Limits

Ctrl + Z (or Cmd + Z on Mac) will undo a column deletion immediately, and Excel's undo history typically allows multiple steps back. However:

Undo history resets when you close and reopen a file
Shared/co-authored workbooks may have limited undo behavior depending on the platform (Excel desktop vs. Excel for the web)
Some macros or Power Query operations can clear the undo stack

If you're deleting columns in a critical dataset, saving a backup copy first — or working on a duplicate sheet — is a reasonable habit regardless of skill level.

When Columns Won't Delete: Common Blockers

A few situations prevent column deletion from working as expected:

Sheet is protected: Column deletion is blocked on protected sheets. You'd need the sheet password to unprotect it first via Review → Unprotect Sheet
Workbook is shared (legacy sharing mode): Certain structural changes including deletions may be restricted
You've selected cells rather than full columns: The delete dialog will ask whether to shift cells left or up — selecting full column headers avoids this prompt entirely
Merged cells: Columns containing merged cells can sometimes produce unexpected behavior; unmerging first prevents issues 🔧

The Factor That Changes Everything: Your Spreadsheet's Structure

How you should delete columns — and how cautious you need to be — depends heavily on what your spreadsheet is actually doing. A simple personal budget with no formulas is a different environment than a workbook where columns are referenced by formulas in other sheets, used as named ranges, or connected to external data sources like Power Query or pivot tables.

Deleting a column that's referenced by a formula elsewhere produces #REF! errors throughout the workbook. Deleting a column that feeds a pivot table's data source requires refreshing the pivot after the fact. And in workbooks built by someone else, the column you're about to remove might be doing something non-obvious.

The mechanics of deletion are consistent across Excel versions. What varies is the downstream effect — and that depends entirely on how your particular file is built.