The quickest way to delete a column

Right-click on the column letter at the top of the spreadsheet — A, B, C, and so on — and select Delete from the menu that appears. Excel removes the entire column and shifts all columns to the right one position to the left. This takes about two seconds and works the same way in Excel for Windows, Excel for Mac, and Excel Online.

If you need to delete multiple columns at once, click on the first column letter, then hold Shift and click on the last column letter you want to remove. Right-click and select Delete. All selected columns disappear in one action.

The column you delete is gone permanently unless you undo the action immediately by pressing Ctrl+Z (Windows) or Command+Z (Mac). After you save the file, there is no way to recover it, so double-check that you have selected the right column before you delete.

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, holding Shift, and clicking the last, then right-click and delete them all at once.
  • Deleting a column shifts all columns to the right one position left, so data that was in column D moves to column C.
  • Use Ctrl+Z or Command+Z immediately after deletion to undo if you removed the wrong column.

Using the menu instead of right-clicking

If you prefer the menu bar, click on the column letter to select the entire column, then go to the Home tab at the top. Look for a button labeled Delete in the Cells group (the exact location varies slightly between Windows and Mac versions). Click the small arrow next to Delete and choose Delete Sheet Columns.

This method works identically to right-clicking, but some people find it easier to remember or prefer not to use the right-click menu. The result is the same: the column vanishes and everything to the right shifts left.

What happens to your data when you delete

When you delete a column, Excel removes every cell in that column from top to bottom, including any formulas, text, or numbers. If other columns contain formulas that reference the deleted column — for example, a formula that adds up values from column B — those formulas will show an error like #REF! because the data they pointed to no longer exists.

Before you delete a column that other formulas depend on, scan your spreadsheet to see if any cells reference it. You can do this by clicking on cells that might contain formulas and looking at the formula bar at the top to see what they calculate. If you delete a column by mistake and realize too late that formulas broke, undo the deletion right away with Ctrl+Z or Command+Z.

Hiding a column instead of deleting it

If you want to temporarily remove a column from view without actually deleting it, you can hide it instead. Right-click the column letter and select Hide. The column disappears from the screen, but the data stays in the file and any formulas that reference it continue to work.

To unhide a column, select the columns on either side of the hidden one, right-click, and choose Unhide. The hidden column reappears. This is useful when you want to clean up your view without risking broken formulas or permanent data loss.

Deleting only the contents of a column

If you want to keep the column itself but remove only the data inside it, click the column letter to select the entire column, then press the Delete key on your keyboard. This clears all the text and numbers from that column but leaves the column structure in place. The column letter still appears at the top, and any formulas that reference it will now show zero or an error depending on how they are written.

This is different from deleting the column itself. Use this method when you want to reuse the column for new data or when you need to preserve the column positions so that formulas in other sheets or workbooks do not break.

Differences between Excel versions

The steps to delete a column are nearly identical across Excel for Windows, Excel for Mac, and Excel Online. Right-click the column letter and select Delete in all three versions. The main difference is keyboard shortcuts: Windows uses Ctrl+Z to undo, while Mac uses Command+Z.

Excel Online (the free version you access through a web browser) works slightly differently because it does not have a traditional menu bar, but the right-click method works the same way. If you use Google Sheets instead of Excel, the process is similar — right-click the column letter and select Delete Column — though the interface looks different.

Frequently Asked Questions

Can I delete a column and keep the data somewhere else?

Not automatically. Before you delete, copy the column first by clicking the column letter, pressing Ctrl+C (or Command+C on Mac), and pasting it into a new location or a different spreadsheet. Then delete the original column. This way you have a backup of the data before it is removed.

What if I delete the wrong column by mistake?

Press Ctrl+Z (Windows) or Command+Z (Mac) immediately to undo the deletion. This restores the column and all its data. If you have already saved the file or closed it, the undo option is no longer available and the column cannot be recovered.

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

Only if those sheets contain formulas that reference the deleted column. For example, if Sheet2 has a formula that adds values from Sheet1 column B, and you delete column B from Sheet1, that formula will show a #REF! error. Deleting a column does not affect other sheets unless they explicitly reference it.

Can I delete multiple non-adjacent columns at once?

Not in a single action. You must delete them one at a time or select adjacent columns only. If you need to remove columns A, C, and E, delete them in order from right to left (E first, then C, then A) so that the column letters do not shift and confuse you.