The fastest way to delete a column

Right-click on the column letter at the top of the spreadsheet — the A, B, C, or whatever letter marks the column you want to remove. A menu will appear. Click "Delete" and the column vanishes. Everything to the right shifts left to fill the space.

That is the whole process. You do not need to select the entire column first, though you can. Clicking the letter itself selects it automatically.

If you delete by accident, press Ctrl+Z (or Cmd+Z on a Mac) when ready and the column comes back.

Key Takeaways

  • Right-click the column letter at the top and select "Delete" to remove the entire column in one step.
  • When you delete a column, all columns to the right shift left automatically — you do not have to move them yourself.
  • Undo with Ctrl+Z or Cmd+Z if you delete the wrong column.
  • If you only want to clear the data without removing the column structure, select the column and press Delete instead of right-clicking.
  • Deleting a column is permanent once you save the file, so double-check before you close the spreadsheet.

Selecting multiple columns to delete at once

If you need to remove several columns that sit next to each other, click the first column letter, then hold Shift and click the last column letter. All columns between them highlight in blue. Right-click any of the highlighted letters and select "Delete".

If the columns are not next to each other — say you want to delete column B and column E but keep C and D — click column B, then hold Ctrl (or Cmd on a Mac) and click column E. Both highlight. Right-click and delete. Excel removes both columns and shifts everything left.

The difference between deleting and clearing

Deleting a column removes the column itself from the spreadsheet. Clearing a column empties the data inside it but leaves the column structure in place. Choose based on what you actually need.

To clear instead of delete: click the column letter to select it, then press the Delete key on your keyboard. The cells become empty, but the column still exists. This is useful when you want to keep the layout of your spreadsheet the same but remove specific data.

Deleting is the right choice when a column no longer serves any purpose and you want to tighten up your spreadsheet. Clearing is the right choice when you are removing temporary data or making room for new entries in the same column.

What happens to formulas when you delete a column

If other cells in your spreadsheet contain formulas that reference the column you are deleting, those formulas will break. Excel shows an error like #REF! in any cell that was pointing to the deleted column.

Before you delete a column that other formulas depend on, search your spreadsheet for any references to it. Click Ctrl+H (or Cmd+H on a Mac) to open Find and Replace, then search for the column letter — for example, search for "C:" to find all references to column C. This shows you which cells will be affected.

If you find formulas that depend on the column, you have two choices: rewrite those formulas to reference a different column, or clear the column instead of deleting it so the formulas keep working.

Deleting columns in a protected spreadsheet

If the spreadsheet is protected — meaning the owner locked it to prevent changes — you may not be able to delete columns. Right-click will either show no "Delete" option or the option will be grayed out.

To delete columns in a protected sheet, you need the password. Ask the person who created or shared the spreadsheet with you. They can unlock it temporarily, or they can delete the column themselves and send you the updated file.

If you own the spreadsheet and forgot the password, there is no built-in way to recover it in Excel. You would need to recreate the spreadsheet or use a third-party tool designed to remove protection, though results vary depending on the version of Excel and the type of protection used.

Recovering a deleted column

If you delete a column and realize the mistake before closing the file, press Ctrl+Z (or Cmd+Z on a Mac) to undo. You can undo multiple times to step back through your recent actions. The column and all its data return.

Once you close and save the file, the deletion is permanent. Excel does not keep a recovery version of deleted columns. If you closed the file without saving, you may be able to recover it through your computer's file history or through Excel's AutoRecover feature, but this depends on your settings and how long ago the file was closed.

To protect yourself, save your spreadsheet with a new name before you delete columns you are unsure about. That way you keep a backup of the original version while you work on the new one.

Deleting columns on a Mac versus Windows

The process is identical on both systems. Right-click the column letter and select "Delete". The keyboard shortcut for undo is Cmd+Z on a Mac instead of Ctrl+Z on Windows, but the deletion itself works the same way.

If you are using Excel Online (the web version), the process is also the same: right-click the column letter and delete. The main difference is that Excel Online saves automatically, so you cannot undo after closing the browser tab.

Frequently Asked Questions

Can I delete a column without losing the data?

Yes. Instead of right-clicking and deleting, select the column and press Delete. This clears the data but keeps the column structure. If you want to save the data before removing it, copy the column first, paste it into a new location or a different spreadsheet, then delete or clear the original.

What if I delete the wrong column by accident?

Press Ctrl+Z (or Cmd+Z on a Mac) when ready. This undoes the deletion and brings the column back with all its data. You can undo multiple times if you need to step back through several actions. Once you close and save the file, undo no longer works.

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

No. Deleting a column only affects the sheet you are currently on. 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 a #REF! error.

Can I delete a column if it contains important data I might need later?

You can, but it is safer to save a copy of the spreadsheet first. Save the file with a new name, then delete the column from the copy. This way you keep the original file with all the data intact. You can always go back to it if you change your mind.

Why does Excel show #REF! error after I delete a column?

This error means a formula in another cell was pointing to the column you deleted. The formula no longer has a valid reference, so it cannot calculate. You need to either undo the deletion or rewrite the formula to reference a different column that still exists.