How to Delete a Column in Excel: Every Method Explained

Deleting a column in Excel sounds simple — and often it is. But depending on how you're working, whether you're on a desktop or mobile, using a mouse or keyboard shortcuts, or dealing with protected sheets and tables, the process changes. Here's a thorough breakdown of every reliable method and what to watch out for along the way.

The Difference Between Deleting and Clearing a Column

Before diving into methods, this distinction matters: deleting a column removes it entirely — the column disappears and everything to the right shifts left. Clearing a column removes the content but leaves the empty column in place.

Most people want a true delete, but if you're trying to preserve column structure (for formulas that reference fixed column positions, for example), clearing might be the better move. This article covers both, but focuses on full deletion.

Method 1: Right-Click to Delete (Most Common)

This is the go-to method for most users:

1. Click the column header — the lettered cell at the top (e.g., "C") to select the entire column.
2. Right-click on the selected header.
3. Choose Delete from the context menu.

The column disappears immediately and adjacent columns shift to fill the gap. This works in Excel for Windows, Excel for Mac, and Excel Online (browser version).

To delete multiple columns at once, hold Ctrl (Windows) or Command (Mac) while clicking multiple column headers, then right-click any selected header and choose Delete. For a range of adjacent columns, click the first header, hold Shift, click the last, then right-click and delete.

Method 2: Keyboard Shortcut

For users who prefer keeping hands on the keyboard:

• Select the column header using Ctrl + Spacebar (selects the entire column of the active cell)
• Then press Ctrl + – (minus sign) on Windows to delete

On Mac, the equivalent is Control + – or Cmd + – depending on your Excel version. If a dialog box appears asking whether to shift cells left or up, choose Entire Column and confirm.

⌨️ Keyboard shortcuts become especially useful when deleting columns repeatedly or as part of a cleanup workflow across a large spreadsheet.

Method 3: Using the Ribbon

If you prefer working through menus:

1. Select any cell in the column you want to delete (or select the full column via the header).
2. Go to the Home tab in the Ribbon.
3. In the Cells group, click the dropdown arrow on Delete.
4. Select Delete Sheet Columns.

This method is reliable and works consistently across versions, making it a good fallback when shortcuts aren't behaving as expected.

Method 4: Deleting Columns in an Excel Table

Excel Tables (created via Insert → Table or Ctrl+T) behave differently from regular cell ranges. When you right-click a column header inside a Table, you'll see options like Delete Table Columns rather than the standard sheet column delete.

This distinction matters: deleting a Table column only removes it from the Table object, not necessarily the entire worksheet column. Depending on your setup, data outside the Table in that same column may remain. If you want to remove the full worksheet column, select the column letter header (outside the Table boundary) and delete from there.

Deleting Columns in Excel Online and Mobile

Excel Online (browser-based) supports right-click column deletion the same way the desktop app does, though a small number of advanced features may behave slightly differently.

Excel for iOS and Android requires a different approach:

• Tap the column header to select it
• Tap again to bring up the context menu
• Select Delete

The mobile interface simplifies options considerably, so some Ribbon-based commands aren't accessible. If you're managing complex spreadsheets, the desktop version gives you significantly more control.

What Can Block a Column Delete 🚫

Several situations can prevent deletion:

The #REF! error scenario is the most common gotcha. If other cells contain formulas like =SUM(C:C) and you delete column C, those formulas break. Before deleting columns in formula-heavy spreadsheets, use Ctrl + ~ (tilde) to toggle formula view, or check dependents via Formulas → Trace Dependents.

Clearing vs. Hiding: When Full Deletion Isn't the Right Call

Sometimes you don't actually need to delete:

• Hiding a column (Right-click header → Hide) keeps the data intact and preserves formula references, while removing it from view. Useful when you need the data but not the visual clutter.
• Clearing content (Select column → Delete key) removes values but keeps formatting and the column structure.

These options matter more as spreadsheet complexity increases — a column that looks unused may be feeding a pivot table, a named range, or a formula elsewhere in the workbook.

When Your Setup Shapes the Experience

The method that works best depends on factors specific to your situation: which version of Excel you're running, whether you're on desktop or mobile, whether the spreadsheet uses Tables or raw ranges, and how interconnected your formulas are. A clean personal budget sheet and a shared financial model at work call for different levels of caution before removing any column permanently.