The fastest way to remove a column you don't need

Right-click on the column letter at the top of the spreadsheet — the A, B, C running along the header. A menu will appear. Click "Delete" and the entire column disappears. Everything to the right shifts left to fill the gap. This works whether the column is empty or full of data.

If you need to delete more than one column at a time, click the first column letter, then hold Shift and click the last column letter you want to remove. All the columns in between will highlight in blue. Right-click and select "Delete" — they all vanish at once.

You can undo this when ready by pressing Ctrl+Z (or Cmd+Z on a Mac). If you realize five minutes later that you deleted the wrong column, undo still works as long as you haven't closed the file.

Key Takeaways

  • Right-click the column letter at the top and select "Delete" to remove an entire column in one step.
  • To delete multiple columns at once, click the first column letter, hold Shift, click the last one, then right-click and delete.
  • Deleting a column shifts everything to its right one position left — plan ahead if your formulas reference columns by letter.
  • Undo with Ctrl+Z when ready after deletion if you removed the wrong column.
  • Hiding a column (right-click, select "Hide") keeps the data but removes it from view, which is safer if you might need it later.

Why you might want to hide instead of delete

Deleting is permanent until you undo it. If you are not sure whether you will need a column later, hiding it is safer. Right-click the column letter and select "Hide." The column vanishes from the spreadsheet, but the data stays in the file. You can unhide it anytime by right-clicking the columns on either side of the gap and selecting "Unhide."

Hiding is also useful when you are sharing a spreadsheet with someone else. You might hide columns that contain notes or calculations you do not want them to see, while keeping the final numbers visible. They cannot accidentally delete what they cannot see.

What happens to formulas when you delete a column

If your spreadsheet contains formulas that reference a deleted column, those formulas will break. For example, if you have a formula that says =A1+B1 and you delete column B, the formula becomes =A1+#REF! — an error that means the reference no longer exists.

Before you delete a column, scan the spreadsheet for formulas that might depend on it. Look for cells containing = signs, or use the Find function (Ctrl+F) to search for the column letter. If formulas do reference that column, either rewrite them first or hide the column instead of deleting it.

If you delete a column by accident and break formulas, undo when ready. Ctrl+Z will restore both the column and the working formulas.

Deleting columns versus clearing their contents

Deleting a column removes it entirely and shifts everything else over. Clearing a column keeps the column in place but empties it of data. The difference matters depending on what you are trying to do.

To clear a column without deleting it, click the column letter to select the entire column, then press Delete. The column stays where it is, but all the data inside it vanishes. This is useful when you want to keep the column structure the same but remove old information.

To delete the column itself, right-click and choose "Delete" from the menu. The column disappears and the columns to the right shift left. Use this when you do not need the column at all and want a narrower spreadsheet.

Selecting and deleting multiple non-adjacent columns

If the columns you want to delete are not next to each other — for example, column B and column E but not C and D — you need a different approach. Click the first column letter, then hold Ctrl (or Cmd on a Mac) and click each additional column letter you want to remove. They will all highlight in blue even though they are not touching.

Right-click any of the highlighted columns and select "Delete." All of them will be removed at once, and the remaining columns will shift left to close the gaps. This is faster than deleting them one at a time.

How to delete columns in a filtered or sorted spreadsheet

If you have applied a filter or sort to your spreadsheet, deleting a column works the same way — right-click the column letter and select "Delete." The filter or sort stays in place on the remaining columns.

Be careful, though. If you have hidden rows because of a filter, deleting a column will delete data from those hidden rows too, even though you cannot see them. If you are not sure what is hidden, remove the filter first (click Data > Filter to toggle it off) before you delete anything.

Frequently Asked Questions

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

Technically yes, but do not do it without undoing when ready if you change your mind. Once you close the file, the deletion is permanent. If the data matters, copy the column to a different location or save a backup copy of the file before you delete anything.

What if I delete the wrong column and close the file?

The data is gone. Undo only works while the file is open. If you closed it, the deletion is permanent. This is why hiding a column is safer than deleting it when you are not completely sure.

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

No. Each sheet in a workbook is separate. Deleting a column in Sheet1 does not touch Sheet2. However, if a formula in Sheet2 references the deleted column in Sheet1, that formula will break and show #REF! error.

How do I delete a column in Google Sheets instead of Excel?

Right-click the column letter and select "Delete column." The process is identical to Excel. You can also select the column and use the menu: click Data > Delete column. Undo works the same way with Ctrl+Z.