The fastest way to delete a column

Right-click on the column letter at the top of the spreadsheet — the letter itself, not a cell inside it. A menu will appear with the option "Delete". Click it, and that entire column disappears. Everything to the right shifts left to fill the space.

If you need to delete multiple columns at once, click the first column letter, then hold Shift and click the last column letter you want to remove. All the columns between them will highlight in blue. Right-click any of the highlighted letters and choose "Delete".

The column is gone immediately — there is no confirmation dialog. If you delete the wrong column by accident, press Ctrl+Z (or Cmd+Z on Mac) right away to undo.

Key Takeaways

  • Right-click the column letter at the top and select "Delete" to remove an entire column in one step.
  • Select multiple columns by clicking the first letter, holding Shift, and clicking the last letter, then right-click and delete them all at once.
  • Deleting a column shifts everything to its right one column to the left, so check what data sits beside the column you are removing.
  • Press Ctrl+Z immediately if you delete the wrong column — Excel will restore it.
  • Use "Clear Contents" instead of "Delete" if you want to empty a column but keep its space in the spreadsheet.

The difference between deleting and clearing a column

When you delete a column, Excel removes it entirely and shifts all the columns to the right one position left. When you clear a column, you erase the data inside it but the column itself stays in place.

Use "Delete" when you no longer need the column at all. Use "Clear Contents" when you want to empty it but keep the column structure — for example, if other columns reference it by position, or if you are reusing a template and want to wipe old data but keep the layout.

To clear instead of delete: right-click the column letter, choose "Clear Contents", and the cells become blank. The column stays where it is.

Deleting columns without breaking formulas

If other cells in your spreadsheet contain formulas that reference the column you are about to delete, those formulas will break. For example, if cell D1 contains the formula =SUM(A1:C1) and you delete column B, the formula becomes =SUM(A1:B1) — it automatically adjusts to skip the deleted column, but the result changes.

Before you delete, scan the spreadsheet for any formulas that use the column. You can search for them by pressing Ctrl+H (or Cmd+H on Mac), which opens Find & Replace. Search for the column letter followed by a number — for example, "B1" — to find cells that reference it.

If you find formulas that depend on the column, either rewrite them first or copy the column's data somewhere else before deleting it, so you have a record of what was there.

Deleting columns from the middle of your data

Deleting a column in the middle of your data works the same way as deleting one from the edge — right-click the column letter and choose "Delete". Everything to the right shifts left immediately.

The risk is that if your data is organized in a specific order, removing a column from the middle can break that structure. For example, if you have columns for First Name, Last Name, and Email in that order, and you delete Last Name, your data now shows First Name, then Email — which might confuse anyone reading the spreadsheet later.

If you are unsure whether you need the column, consider hiding it instead of deleting it. Right-click the column letter, choose "Hide", and the column disappears from view but stays in the file. You can unhide it later by right-clicking the columns on either side and choosing "Unhide".

Deleting many columns at once

If you need to remove 10 or 20 columns, selecting them one by one is slow. Instead, click the first column letter you want to delete, then hold Shift and click the last one. All columns in between will highlight in blue. Right-click any of the highlighted letters and choose "Delete" — they all vanish in one action.

You can also select non-consecutive columns by clicking the first one, then holding Ctrl (or Cmd on Mac) and clicking each additional column letter. When you right-click and delete, only the columns you selected will be removed.

Be careful with non-consecutive deletions — it is easy to accidentally select the wrong columns. If you make a mistake, press Ctrl+Z to undo.

What happens to your data when you delete a column

When you delete a column, the data in that column is gone. Excel does not move it to a trash folder or recovery area — it is removed from the file. The only way to get it back is to undo immediately with Ctrl+Z, or to close the file without saving and reopen the last saved version.

If you have already saved the file after deleting the column, the data is permanently lost. This is why it is a good idea to save a backup copy of important spreadsheets before you start deleting columns, especially if you are not certain which ones you need.

If you realize you deleted the wrong column after you have already saved, check whether your computer or cloud storage service (like OneDrive or Google Drive) keeps version history. Many do, and you may be able to restore an earlier version of the file.

Deleting columns in different versions of Excel

The method is the same in Excel for Windows, Excel for Mac, and Excel Online: right-click the column letter and choose "Delete". The menu looks slightly different depending on which version you use, but the option is always there.

In Excel Online (the free version you access through a web browser), you can also use the menu bar: click the column letter to select it, then go to Home > Delete > Delete Sheet Columns. This takes more steps than right-clicking, but it works the same way.

If you are using an older version of Excel (2010 or earlier), the process is identical — right-click the column letter and choose "Delete".

Frequently Asked Questions

Can I undo deleting a column after I have closed the file?

No — once you close the file, the undo history is gone. If you saved the file after deleting the column, the data is lost. Check your cloud storage or computer backup to see if an earlier version of the file is available.

What if I delete a column by accident and I have already saved?

If you use OneDrive, Google Drive, or Dropbox, these services often keep version history. Right-click the file in your cloud storage and look for "Version history" or "Restore previous versions". You may be able to recover an earlier copy of the spreadsheet.

Does deleting a column affect other sheets in the same workbook?

No — deleting a column only affects the sheet you are currently viewing. Other sheets in the same workbook are not changed. However, if another sheet contains a formula that references the deleted column, that formula will show an error.

Can I delete a column if it contains formulas?

Yes, you can delete any column regardless of what it contains. But if other cells reference that column in their formulas, those formulas will break and show an error. Check for references before you delete.

Is there a keyboard shortcut to delete a column without right-clicking?

Not a direct one, but you can select the column by clicking its letter, then use the menu: Home > Delete > Delete Sheet Columns. Right-clicking is faster for most people.