Spreadsheets get messy. You import a CSV, paste in a report, or inherit a workbook from a coworker, and suddenly half the columns are useless. Knowing how to delete columns in Excel the right way saves hours of cleanup, and it protects you from accidentally wiping out formulas that other sheets still depend on.

This guide covers every method that actually works in Microsoft Excel 365, 2024, 2021, and the web version. You'll learn the right-click trick most people stop at, the keyboard shortcuts that pros use to clear dozens of columns in seconds, and the VBA snippets that handle delete jobs across entire workbooks. We'll also flag the traps, like why pressing Delete on your keyboard does NOT remove a column, and what to do when Excel claims a column has data even though it looks empty.

You don't need to be a power user to follow along. If you can open a workbook and click a column letter, you're ready. Let's clear out the clutter.

The Quick Answer: Three Ways to Delete a Column Fast

Before we go deep, here's the short version. To remove a column in Excel, you have three reliable options. Right-click the column letter at the top of the sheet and choose Delete. Or click any cell in the column, press Ctrl + Spacebar to highlight the whole column, then press Ctrl + - (the minus key). Or select the column letter and use the Home tab's Delete dropdown on the ribbon.

Each method removes both the cells and any formatting. The column header letters then shift left, so what was column D becomes column C. Sounds simple. It is, until you have hidden columns, merged cells, table formatting, or formulas pointing to the column you just nuked. That's where things get interesting.

Method 1: Delete a Single Column with Right-Click

This is the method most people learn first, and it works in every version of Excel from 2007 onward. Here's the exact sequence.

1. Open your workbook and navigate to the sheet that contains the column you want to remove.
2. Move your cursor to the gray header bar at the top of the spreadsheet. The cursor turns into a small downward-pointing arrow when you hover over a column letter.
3. Click the column letter once. The entire column highlights in light blue or gray.
4. Right-click anywhere inside the highlighted column. A context menu appears.
5. Click Delete. The column vanishes, and every column to its right shifts one position left.

That's the whole process. No confirmation dialog, no second clicks. The action is instant, but it lives in your undo history, so Ctrl + Z brings the column back if you change your mind. Good news: undo works even after you save (in Excel 365), as long as you haven't closed the workbook.

Method 2: The Keyboard Shortcut (Ctrl + Minus)

If you delete columns more than once a day, learn this shortcut. It's faster than reaching for the mouse and faster than any ribbon menu.

The combination is Ctrl + - (Control plus the minus sign on the main keyboard, not the numpad minus, though that usually works too). Here's how to use it without triggering a confusing dialog box.

Step-by-Step Shortcut Method

1. Click any cell inside the column you want to remove.
2. Press Ctrl + Spacebar. This selects the entire column from row 1 to row 1,048,576. The column header turns dark to confirm.
3. Press Ctrl + -. Because the whole column is already selected, Excel deletes it immediately. No dialog appears.

If you skip step 2 and press Ctrl + - with only a cell selected, Excel pops up the Delete dialog and asks whether you want to shift cells left, shift cells up, delete the entire row, or delete the entire column. Pick Entire column and click OK. Same result, one extra click. Selecting the column first skips the dialog and feels seamless.

On a Mac, the equivalent is Cmd + -. Some keyboards require you to hold Fn if the minus key is shared with another function. Test it once and you'll know which combo your laptop wants.

Method 3: Use the Ribbon (Home Tab)

The ribbon route is slower but obvious to anyone who has just opened Excel for the first time. It's also handy when your hands are already on the mouse for other formatting tasks.

1. Select the column or columns by clicking the column letters at the top.
2. Go to the Home tab on the ribbon.
3. In the Cells group, click the small arrow under Delete.
4. Choose Delete Sheet Columns.

Done. The same Home tab houses Insert and Format dropdowns, so once you know where the Delete button lives, you're set for a lot of basic cell operations.

Deleting Multiple Columns at Once

Need to clear five columns or fifty? Don't repeat the single-column process over and over. Excel lets you remove batches in one operation, and the methods differ slightly depending on whether the columns are next to each other.

Adjacent Columns

Click the first column letter, hold Shift, click the last column letter. Every column between them highlights. Right-click anywhere in the selection and choose Delete.

Non-Adjacent Columns

This is where Ctrl earns its keep. Click the first column letter, then Ctrl-click each additional column letter, even if they're far apart. Mix and match, like B, F, and L. Right-click and Delete. Excel removes them all at once.

How to Delete Hidden or Blank Columns in Excel

Hidden columns are the worst kind of clutter. You can't see them, but they still consume memory and trip up macros. If a column letter jumps from C to E, column D is hidden. Select the entire sheet by clicking the gray triangle in the top-left corner, then right-click any column letter and pick Unhide. Every hidden column reappears.

Delete Blank Columns Quickly

Select your data range, press F5, click Special, choose Blanks, click OK. Every blank cell highlights. Right-click on one of them, choose Delete, and pick Entire column. The catch: it only checks the row you originally selected. For a deeper sweep, use a helper row formula like =COUNTA(A2:A1000) and filter for zero counts, then delete those columns by hand.

Delete Columns with VBA Macros

For repeating jobs, VBA is your friend. A macro that wipes the same columns from every weekly report saves real time. Open the Visual Basic editor with Alt + F11, insert a module, and paste in a routine like the one below.

Here's a clean macro that removes a single named column:

Sub DeleteColumnB()
    Columns("B").Delete
End Sub

That removes column B from the active sheet. Need to remove multiple columns? Reference them as a range:

Sub DeleteMultipleColumns()
    Columns("B:D").Delete
    Columns("G:G").Delete
End Sub

The macro deletes columns B through D, then column G. Excel handles the column shifts internally, so you don't need to worry about index changes mid-routine, as long as you delete from right to left when using numbers, or use named ranges as shown.

Deleting Empty Columns with VBA

This one's a workhorse. It scans every column in the used range and removes any column where every cell is empty.

Sub DeleteEmptyColumns()
    Dim col As Long
    Dim lastCol As Long
    lastCol = Cells.Find("*", SearchOrder:=xlByColumns, _
        SearchDirection:=xlPrevious).Column
    For col = lastCol To 1 Step -1
        If Application.CountA(Columns(col)) = 0 Then
            Columns(col).Delete
        End If
    Next col
End Sub

Run that on a sheet full of empty filler columns and watch them vanish. The loop goes backwards (right to left) so deleting a column doesn't break the index for the columns still to check.

If you're new to macros, save your workbook as .xlsm (macro-enabled workbook) before running. Excel won't keep the macro otherwise.

Common Errors and Fixes

Most column-delete problems are easy to recover from, but a few will make you sweat if you don't know what to look for. Here are the common issues and the quickest fixes.

#REF! Errors After Deletion

If you see #REF! in cells that used to show numbers, a formula in those cells was pointing to a column you just deleted. Press Ctrl + Z immediately if you can. If you've already saved, you'll need to rebuild the formulas manually or restore from a backup. To find every #REF! error at once, use Find (Ctrl + F), type #REF!, and click Find All.

"Cannot Shift Objects Off Sheet" Error

This error shows up when a chart, image, or shape on the sheet would have to move into space that doesn't exist if the column is removed. To fix it: select the offending object, open its Format properties, find the Properties section, and set the object to Move and size with cells. Then retry the delete.

Table Column Won't Delete

If you're working inside an Excel Table (created with Ctrl + T), the right-click menu offers Delete > Table Columns, not Sheet Columns. Using the sheet command on a table column can wipe out neighboring table data. Always pick Table Columns when working inside a structured table.

Hidden Column That Won't Delete

Select the columns on either side of the hidden one (for example, columns C and E if D is hidden). Right-click and choose Unhide. Now you can see column D and remove it normally. Alternatively, drag the column boundary in the header to widen the hidden column first, then delete it.

How to Delete Extra Columns Excel Won't Stop Adding

One of the weirdest spreadsheet issues: you delete the unused columns at the right edge, save the file, reopen it, and Excel has added them right back. The reason? Excel tracks a "used range" that includes any cell that ever had formatting, even if the data is gone. The file behaves like the columns are still in use, and the file size stays bloated.

The Fix: Reset the Used Range

1. Click the first cell in the first unused column.
2. Press Ctrl + Shift + End. This selects everything from your cursor to the last "used" cell in the sheet.
3. On the Home tab, click Clear in the Editing group, then Clear All. This removes content and formatting.
4. Save the workbook, close it, and reopen.

Excel recalculates the used range when the file reopens. The phantom columns should be gone, and the file size usually drops too. If they come back again, repeat the process on every sheet in the workbook, since the issue is per-sheet, not per-file.

Power Query: Remove Columns Without Touching the Source

If you load data from a CSV, database, or another workbook, Power Query is the cleanest way to drop unwanted columns. The original file stays untouched, and the column removal becomes a step you can repeat every time new data arrives.

1. On the Data tab, click Get Data and pick your source (From File, From Web, From Database, and so on).
2. When the Power Query Editor opens, find the columns you don't need.
3. Right-click a column header and choose Remove. Or select multiple columns with Ctrl-click and use the Remove Columns button on the Home tab. There's also Remove Other Columns, which keeps only the ones you selected.
4. Click Close & Load to send the cleaned data back to a sheet.

The big advantage: Power Query records every step. Next month, when you get a new CSV with the same junk columns, click Refresh All on the Data tab and your trimmed dataset reappears, fresh and clean. This is how analysts handle reports that arrive on a schedule.

When Should You Hide Instead of Delete?

Deletion is permanent (after save). Hiding is reversible. If you're not 100 percent sure a column is useless, hide it instead. Right-click the column letter and choose Hide. The column stays in the file, formulas still reference it correctly, but it's out of view. To bring it back, select the columns on either side, right-click, and choose Unhide.

Hiding is the right choice when a column holds calculations that feed other sheets, helper data for VLOOKUPs or charts, or sensitive info that shouldn't show on a printout. Deletion is the right choice when the column is truly garbage and you want a leaner file.

Quick Reference: All the Methods at a Glance

Here's a fast cheat sheet you can screenshot or print. Each method has its moment, and the more you use Excel, the more you'll switch between them naturally.

• Right-click column letter > Delete: Best for beginners and one-off deletions.
• Ctrl + Spacebar, then Ctrl + Minus: Fastest for power users with hands on keyboard.
• Home tab > Delete dropdown > Delete Sheet Columns: Easiest to find for new Excel users.
• Select column letters, right-click, Delete: Works for adjacent (Shift + click) and non-adjacent (Ctrl + click) groups.
• Name Box: type range like H:ZZ, press Enter, then delete: Best for huge ranges in cluttered files.
• F5 > Go To Special > Blanks > Delete > Entire column: Removes blank columns from a selected range.
• VBA macro: Best for repeated jobs across many files or sheets.
• Power Query: Best for cleaning data from external sources without altering the original file.

The Microsoft Office documentation has good background on column and row limits if you want to read more, but every method above works straight out of the box. No extras, no add-ins.

Practice on a Sample Workbook

Knowledge without practice fades fast. The best way to lock in these column-delete skills is to open a junk workbook (or copy one of your real ones), and try every method. Delete a column with the right-click menu. Undo it. Delete the same column with the shortcut. Undo it again. Then try multi-column deletes. Try a non-adjacent selection. Run the Go To Special blanks trick. Try a VBA snippet if you're feeling adventurous. Five minutes of hands-on practice beats an hour of reading.

If you want to test your overall Excel knowledge after, take a free practice quiz that covers column operations, formulas, formatting, and more. It's a quick way to find gaps before you tackle a certification exam or apply for a data-heavy job.

Final Tips Before You Delete Anything

You came here looking to remove some columns. By now you've got eight different ways to do it. The big takeaways: right-click and Delete is the universal starter move; Ctrl + Spacebar followed by Ctrl + - is the speed king once you've practiced it a few times; and Power Query is the smart pick when you're cleaning recurring imports.

Before you delete anything in a production workbook, save a copy. Check for formula dependencies with Ctrl + `. Watch for hidden columns by clicking the corner triangle and unhiding all. And remember that an Excel Table needs the Table Columns delete option, not the sheet one.

Excel is one of those tools where small skills compound into real time savings. Five seconds saved per column delete adds up to hours over a year when you handle data for a living. Pick the method that feels right for the task in front of you, build the muscle memory, and your spreadsheets will start looking a lot cleaner. Need a fast skill check? Run through a free Excel practice test and see where you stand.