How to Delete a Column in Excel: Step-by-Step Guide

Why Knowing How to Delete a Column in Excel Matters More Than You Think

You open a spreadsheet someone else built. Eighty-six columns, half empty, three duplicated, and one filled with a single repeated value nobody can explain. Before you can do anything useful with this file, you need to clean it up. That cleanup almost always starts with the same task: deleting columns you do not need.

It sounds trivial. It is not. The wrong delete in the wrong place can break a formula referenced by twelve other workbooks, wipe out a hidden column you forgot was hidden, or corrupt a pivot table that took an hour to build.

This guide walks you through every reliable method for removing columns in Excel, from the one-second keyboard shortcut to the more surgical VBA approach for repeating jobs. We cover what changes when you delete versus clear, how to handle multiple columns at once, what happens to your formulas, and how to recover when you delete the wrong thing.

The Fastest Way to Delete a Single Column

Click the column letter at the top of the column you want to remove. The whole column highlights in dark green. Now press Ctrl + minus sign (Ctrl + -) on Windows, or Command + minus on a Mac. The column vanishes and everything to the right shifts left. That is the shortcut every Excel power user has burned into their fingers.

If you prefer the mouse, right-click on the column letter and choose Delete from the menu that pops up. Same result. The ribbon path also works: select the column, go to the Home tab, find the Cells group, click the arrow under Delete, and pick Delete Sheet Columns.

Watch what happens to the column letters after the delete. If you had columns A through F and you deleted column C, the column that used to be D is now called C. Excel renames everything to the right. This matters because any formula that referenced column D by letter, like =D5*1.2, now references the new column C and may return a different value.

Delete Versus Clear: Two Different Outcomes

People mix these up constantly. Deleting a column removes the entire column from the sheet and shifts the remaining columns left. Clearing a column wipes the contents but leaves the empty column in place. The column letters do not shift.

To clear a column without deleting it, select the column and press Delete on your keyboard (the big Delete key, not Ctrl + -). The cells go blank. Their formatting stays. If you also want to wipe formatting, comments, and hyperlinks, use the Home tab, find Clear in the Editing group, and pick Clear All.

Choose clear when other formulas reference the column by its current letter and you want those references intact but pointing at empty cells. Choose delete when you want the column gone for good and you do not care if neighboring columns slide over to take its place.

Deleting Multiple Columns at Once

You rarely need to delete just one column. Most cleanup jobs involve five, ten, or twenty unwanted columns scattered across a sheet.

For adjacent columns, click the first column letter, hold Shift, and click the last column letter. All the columns between them highlight. Press Ctrl + - and they all disappear together. This is faster than deleting one at a time because Excel only recalculates dependent formulas once instead of once per column.

For columns that are not next to each other, click the first column letter, hold Ctrl, and click each additional column letter you want to remove. The selected columns highlight even though they are not contiguous. Press Ctrl + - and Excel deletes all of them in one operation, sliding the remaining columns left to close the gaps.

What Happens to Your Formulas When You Delete a Column

This is where careful work pays off. Excel handles deleted columns in three different ways depending on what your formulas look like.

If a formula references the deleted column directly, like =SUM(C2:C100), and you delete column C, the formula returns #REF!. That is Excel telling you a referenced cell no longer exists. The fix is either undo the delete or rewrite the formula to point at a different column.

If a formula references columns to the right of the deleted column, like =SUM(F2:F100) and you delete column C, the formula updates automatically to =SUM(E2:E100). Excel shifts the reference left because the data shifted left.

If a formula uses an absolute reference with the dollar sign, like =SUM($F$2:$F$100), Excel still updates the reference when columns to the left are deleted. The dollar signs lock the reference from changing when you copy the formula, but they do not protect against structural changes to the sheet itself. The closest workaround is the INDIRECT function: =SUM(INDIRECT("F2:F100")). Because the cell address is just a text string, Excel never updates it.

Using VBA to Delete Columns Automatically

If you find yourself deleting the same columns every week from a recurring report, write a macro. The basic syntax is simple. Open the VBA editor with Alt + F11, insert a new module, and paste in a procedure like this:

Sub DeleteUnwantedColumns()
    Columns("D:D").Delete
    Columns("H:J").Delete
End Sub

Run the macro and Excel removes column D, then columns H through J. Notice the order matters. After deleting column D, what was column E becomes the new D. To avoid this confusion, always delete columns from right to left, or reference them by name rather than letter.

To delete columns based on their header text, loop through row 1 and check each value. The loop runs from right to left (Step -1) so that deletions do not shift the columns we have not yet checked. This pattern handles any number of unwanted columns identified by their header text.

Save the macro inside your Personal Macro Workbook (PERSONAL.XLSB) so it loads with every Excel session and is callable from any file. Assign it to a keyboard shortcut through the Macros dialog (Alt + F8) by clicking Options and typing a letter. From then on, the cleanup that used to take five minutes happens with one keypress. Production teams that run dozens of reports each week typically save hours per month by automating the column-removal step.

One subtle gotcha: Columns("D:D").Delete uses the spreadsheet column letter. If a colleague reorganizes the source file and your unwanted column moves from D to E, the macro deletes the wrong column. Loop by header text instead of letter when the source structure might change. The extra lines of code pay for themselves the first time a teammate renames or rearranges columns upstream of your script.

Deleting Columns Inside a Table

If your data lives inside an Excel Table (created with Ctrl + T), deleting a column behaves differently. Right-click any cell in the column and choose Delete from the menu. Excel offers two options: Table Columns and Sheet Columns.

Pick Table Columns to remove the column from your table only, leaving any data outside the table untouched. Pick Sheet Columns to remove the entire column from the worksheet, which affects everything in the same column whether or not it is part of the table.

Table column deletion is generally safer because it respects the boundaries of your structured data. If you accidentally delete a Sheet Column when you meant Table Column, you might wipe out unrelated data sitting below the table. Always read the dialog before clicking OK.

Recovering a Column You Deleted by Mistake

Press Ctrl + Z immediately. Excel keeps up to 100 undo steps in memory, so you can roll back several actions to recover a column even if you have done other things since the delete. The undo history is per-session, meaning closing the workbook clears it.

If you already saved and closed the file, check AutoRecover. Go to File, Info, Manage Workbook, and look for previous versions. Excel saves an AutoRecover snapshot every 10 minutes by default. You may find a version from before the delete.

For files on OneDrive or SharePoint, the version history is more reliable. Click the file name in the title bar, choose Version History, and pick a version from before the delete. Restore it to roll the entire workbook back, or open the older version side by side and copy the deleted column back into the current file.

If none of those routes work and the data is truly gone, you may need to rebuild the column from source data, a backup, or an email attachment of an earlier version. This is why saving frequently with versioned filenames matters: a daily snapshot named with the date catches problems before they become permanent. Keeping a separate backup folder synced to an external drive or cloud service costs little and saves you the day you accidentally delete the wrong thing on a deadline. Treat backups as cheap insurance against your own bad keystrokes.

Shared workbooks deserve extra care. Rollback might affect colleagues who saved newer edits after yours, so coordinate with the team before restoring an old version. A quick message in Teams or Slack saves hours of confused emails later.

Common Errors and How to Fix Them

Cannot shift objects off sheet. Excel shows this error when shapes, charts, or images are anchored in the column being deleted or in columns that need to shift. Go to File, Options, Advanced, and under Display options for this workbook find the For objects, show setting. Change it to All, then locate and reposition the offending object.

The selected column contains a formula. This is a warning, not an error. Excel is telling you that deleting the column will affect formulas elsewhere. Click OK to proceed if you understand the consequences, or Cancel to back out and check Trace Dependents first.

Protected sheet errors. If the worksheet is protected, you cannot delete columns until you unprotect it. Go to Review tab, Unprotect Sheet, enter the password if one is set, and try the delete again. Reprotect when finished.

Merged cells block deletion. If the column you want to delete contains merged cells that span into other columns, Excel may refuse or behave unpredictably. Unmerge the cells first by selecting them and clicking Merge & Center to toggle off.

Quick Reference: Every Delete Method at a Glance

For a single column, click the column letter and press Ctrl + -. For multiple adjacent columns, Shift-click to extend the selection, then Ctrl + -. For non-adjacent columns, Ctrl-click each one, then Ctrl + -. For a column inside a table, right-click a cell and choose Delete, Table Columns. For automated jobs, write a VBA macro that loops from right to left through the columns you want gone.

For every method, the cardinal rule is to save a backup first when the data matters. Whether you are tidying a quick personal budget or preparing a quarterly report that ten executives will see, the mechanics of deleting a column are the same. What differs is the cost of getting it wrong.

Build the habit of pausing for a second before pressing Ctrl + -, ask yourself if anything depends on this column, and only then act. That one-second pause has saved more spreadsheets than any backup policy. Excel certification exams and job interview tests routinely ask candidates to demonstrate fluency with column operations, and hands-on practice is the only way to build the muscle memory that makes these tasks invisible during a busy workday.

Pro Tips From Daily Excel Use

Power users develop personal rituals to avoid disasters. Before pressing Ctrl + -, glance at the formula bar to confirm the active cell is in the column you intend to delete. The header letter of the selected column also highlights in dark green, which is your second visual confirmation. If both signals agree, proceed. If they disagree, you have selected a different column than you think.

Another habit worth building is the use of named ranges for any column referenced by complex formulas. Instead of =SUM(C2:C100), define a named range called Revenue that points at C2:C100, then use =SUM(Revenue). When you delete or move the column, you only need to update the named range definition in Name Manager, not every formula that referenced the column. Named ranges turn structural changes from a forest fire into a single line edit.

When You Are Cleaning a Massive Spreadsheet

Spreadsheets with hundreds of columns benefit from a different workflow. Instead of deleting columns one by one, first hide all the columns you want to keep, then select everything visible and delete. With only the unwanted columns showing, your selection cannot accidentally include data you needed.

To do this, select the columns you want to keep, right-click, and choose Hide. The columns vanish from view but the data remains. Now select the visible columns (which are the ones you do not need), and press Ctrl + -. Excel deletes only what you can see. Finally, unhide everything by selecting all columns and choosing Unhide.

This inverted approach is slower for small jobs but far safer for cleaning a sheet with 200 columns where most need to go. The visual feedback prevents mistakes because you never have to remember which columns are which.