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 appears. Click "Delete" and the entire column vanishes. Everything to the right shifts left to fill the space.

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

You can also select columns by clicking their letters, then going to the Home tab at the top, finding the "Delete" button in the Cells group, and clicking the small arrow next to it. Choose "Delete Sheet Columns" from the dropdown.

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 delete them all at once.
  • Deleting a column shifts all columns to the right one position left and cannot be undone if you close the file without saving.
  • If you delete a column by mistake, press Ctrl+Z when ready to undo the action before you do anything else.

Why you might delete a column instead of hiding it

When you delete a column, it is completely gone and the file size shrinks slightly. When you hide a column, it stays in the spreadsheet but does not show on screen — the column letters skip from C to E, for example, if D is hidden.

Delete a column when you are certain you will never need that data again and you want a cleaner spreadsheet. Hide a column when you want to keep the data but do not need to see it right now, or when you are sharing the spreadsheet with someone who should not see that information.

How to hide a column instead

Right-click the column letter and choose "Hide". The column disappears from view but stays in your file. To bring it back, right-click the column letters on either side of the gap and choose "Unhide".

Hiding is safer than deleting because you can always unhide the column later. If you delete a column and then close the file without saving, the deletion is permanent. If you delete a column, save the file, and then realize you needed that data, you cannot get it back from within Excel.

What happens to formulas when you delete a column

If you have a formula that refers to a cell in the column you are deleting, that formula breaks. For example, if column C contains a formula that adds up values in column D, and you delete column D, the formula shows an error like #REF!.

Before you delete a column, scan your spreadsheet for formulas that might depend on it. Look for cells with equals signs at the start, or use the Find & Replace tool (Ctrl+H) to search for the column letter inside formulas. If you are not sure whether a column is used, hide it first instead of deleting it.

Deleting columns in a shared spreadsheet

If the spreadsheet is shared with others through OneDrive, Google Drive, or another cloud service, deleting a column affects everyone who has the file open. Excel will warn you that the file is in use and ask whether you want to continue. Click "Yes" to delete the column anyway.

Other people working in the spreadsheet at the same time may see the deletion happen in real time, or they may see it the next time they refresh their view. If someone else is editing a cell in the column you delete, their work in that cell is lost.

Recovering a deleted column

If you delete a column by mistake, press Ctrl+Z when ready. This undoes the deletion and brings the column back. You can undo multiple steps in a row by pressing Ctrl+Z again and again.

If you have already saved the file after deleting the column, you cannot undo the deletion within Excel. Your only option is to check whether your computer or cloud service keeps automatic backups. OneDrive and Google Drive both keep version history — you can right-click the file and look for "Version history" or "Restore previous versions" to recover an older copy of the spreadsheet.

Deleting columns without losing your place

When you delete a column, everything shifts left. If you are working on a specific column and delete the one next to it, your view jumps and you lose your place. To avoid this, use the Name Box — the field that shows the cell address, usually in the top left corner of Excel.

Click the Name Box, type the cell address you want to return to after the deletion (like D5), and press Enter. Excel remembers that location. After you delete a column, click the Name Box again and type the same address. Excel takes you back to the same spot, even though the columns around it have shifted.

Frequently Asked Questions

Can I delete a column if it contains data I have not backed up?

You can, but you should not. Before you delete any column, copy the data to another location — paste it into a new sheet, email it to yourself, or save it in a separate file. Once you delete a column and save the file, the data is gone unless your cloud service keeps backups.

What is the difference between deleting and clearing a column?

Deleting removes the entire column and shifts everything to the left. Clearing removes only the data inside the column but leaves the column itself in place. To clear a column, select it, right-click, and choose "Clear Contents". The column stays, but it is now empty.

Does deleting a column affect the row numbers?

No. Deleting a column only shifts other columns left. Row numbers stay the same. If you delete a row instead, the row numbers shift up, but columns are not affected.

Can I delete a column in a read-only spreadsheet?

No. If the spreadsheet is marked read-only, you cannot make any changes, including deleting columns. You must first save a copy of the file that you can edit, or ask the person who shared it to give you editing permission.