The fastest way to remove a column

Right-click on the column letter at the top of the spreadsheet — the letter itself, not a cell inside it. A menu appears. Click Delete. The column vanishes, and all columns to the right shift left to fill the space.

That is the whole process. Excel removes the column and everything in it permanently. If you delete by mistake, press Ctrl+Z (or Cmd+Z on Mac) when ready to undo.

The column letter is the clickable target. If you click inside a cell instead, the right-click menu offers different options and will not delete the column.

Key Takeaways

  • Right-click the column letter at the top, not a cell inside the column, then select Delete from the menu.
  • Deleting a column removes all data in that column and shifts remaining columns to the left.
  • You can delete multiple columns at once by selecting several column letters before right-clicking.
  • Pressing Ctrl+Z (or Cmd+Z on Mac) when ready after deletion will undo the action and restore the column.
  • Hiding a column instead of deleting it keeps the data intact if you might need it later.

Deleting multiple columns at the same time

Click the first column letter you want to remove. Hold Shift and click the last column letter in the range. All columns between them highlight in blue. Right-click any highlighted column letter and select Delete.

If the columns are not next to each other, click the first column letter, then hold Ctrl (or Cmd on Mac) and click each additional column letter you want to remove. They all highlight. Right-click and select Delete.

Excel removes all selected columns in one action. The remaining columns shift left to close the gap.

Hiding a column instead of deleting it

Sometimes you want a column out of sight but do not want to lose the data. Right-click the column letter and select Hide. The column disappears from view, but the data stays in the file.

To bring a hidden column back, click the column letter before the hidden one and the column letter after it, then right-click and select Unhide. The hidden column reappears between them.

Hiding is useful when you have reference data or calculations you need in the spreadsheet but do not want to see while you work. Deleting removes the data entirely, so use hide when you are uncertain.

What happens to formulas when you delete a column

If another cell contains a formula that refers to the deleted column, that formula breaks. Excel shows #REF! in the cell where the formula was, which means the reference no longer exists.

Before you delete a column, scan the spreadsheet to see if any formulas point to it. Look for cells that contain formulas like =A1+B2 or =SUM(C:C). If a formula refers to the column you are about to delete, either update the formula first or hide the column instead of deleting it.

If you delete by mistake and break formulas, undo with Ctrl+Z to restore the column and the formulas.

Deleting empty columns to clean up your spreadsheet

If you have blank columns between your data, removing them makes the spreadsheet easier to read and work with. The process is the same: right-click the column letter and select Delete.

Empty columns often appear after you delete data from a column or copy data from another source. Removing them does not affect any remaining data, since there is nothing in them to lose.

If you are unsure whether a column is truly empty, click the column letter to select the entire column, then look at the formula bar or scroll through to check. A column that looks empty might contain a space or a formula that produces no visible result.

Using the Edit menu to delete columns

If right-clicking does not work or you prefer menu navigation, you can delete through the ribbon. Select the column letter, then click the Home tab at the top. In the toolbar, find the button that looks like a minus sign or says Delete. Click the small arrow next to it and select Delete Sheet Columns.

This method takes more clicks than right-clicking, but it works the same way. The column is removed and columns to the right shift left.

Frequently Asked Questions

Can I delete a column if it contains data I need?

No — deleting removes the data permanently. If you think you might need the column later, hide it instead by right-clicking the column letter and selecting Hide. You can unhide it anytime. If you delete by mistake, press Ctrl+Z when ready to undo.

What is the difference between deleting and clearing a column?

Deleting removes the entire column and shifts other columns left. Clearing removes only the data inside the column but leaves the column itself in place. To clear without deleting, select the column, press Delete, and the data vanishes but the column stays.

Will deleting a column affect other sheets in the same file?

Only if another sheet contains a formula that refers to the deleted column. That formula will show #REF! error. Deleting a column in one sheet does not automatically delete columns in other sheets.

How do I delete a column in Google Sheets?

Right-click the column letter and select Delete column. The process is nearly identical to Excel. You can also select the column and use the menu: click Edit, then Delete column.

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

Yes. Before you delete, select the column, copy it (Ctrl+C), paste it into a new location or a different sheet, then delete the original column. This way the data is preserved in the new location before the column is removed.