The fastest way to remove a duplicate column

If you have accidentally copied a column or imported data that created duplicates, the quickest fix is to delete the column manually. Right-click the column header letter (the letter at the very top of the column), select Delete, and the column disappears. Excel does not have a built-in "remove duplicate columns" button the way it has one for duplicate rows, so you will identify which columns are duplicates by looking at them, then delete the ones you do not need.

This works because duplicate columns are usually obvious — you can see two columns with the same header name or the same data in the same order. If your spreadsheet is small enough to scan visually, this is the method that takes the least time. If you have dozens of columns and cannot easily spot which ones repeat, you will need a different approach.

Key Takeaways

  • Right-click any column header letter and select Delete to remove that column permanently from your spreadsheet.
  • Excel does not automatically flag duplicate columns, so you must identify them by comparing the data yourself or by sorting columns side by side.
  • If you are unsure whether a column is truly a duplicate, copy it to a new sheet first so you can compare it before deleting.
  • Deleting a column cannot be undone if you close the file without saving, so use Ctrl+Z when ready if you delete the wrong column.

How to spot duplicate columns before you delete

Before you delete anything, move the columns next to each other so you can compare them side by side. Click the column header letter, hold it, and drag it to a new position. This lets you see whether the data is truly identical or just similar-looking.

Pay attention to the column header name first — if two columns have the same name, they are almost certainly duplicates. Then scroll down through the data in both columns. If every row matches exactly, the column is a duplicate. If some rows differ, the columns are not duplicates and both should stay.

A common source of confusion is columns that look similar but are not identical. For example, you might have a "Date" column and a "Date Entered" column, or a "Name" column and a "Full Name" column. These are not duplicates — they serve different purposes. Only delete a column if you are certain the data is exactly the same in both.

Deleting a single column you have identified

Once you have confirmed that a column is a duplicate, right-click the column header letter (the gray box at the top with the letter A, B, C, and so on). A menu will appear. Click Delete. The column will vanish, and all columns to the right will shift one position to the left.

If you delete the wrong column by mistake, press Ctrl+Z when ready to undo. This restores the column as long as you have not closed the file. If you have already closed the file, the deletion is permanent and cannot be recovered unless you have a backup.

Repeat this process for each duplicate column you have identified. There is no way to delete multiple columns at once based on a rule — you must delete them one at a time.

Deleting multiple duplicate columns at once

If you have several duplicate columns in a row, you can select them all and delete them together. Click the header letter of the first duplicate column, then hold Ctrl and click the header letters of the other duplicates. All selected columns will highlight in blue. Right-click any of the highlighted columns and select Delete. All selected columns will disappear at once.

This method is faster than deleting one column at a time, but it only works if you are certain all the selected columns are duplicates. If you accidentally select a column you want to keep, click somewhere else to deselect and start over.

Using Find and Replace to locate duplicate column headers

If your spreadsheet has many columns and you are not sure which ones are duplicates, use Find and Replace to search for the column header name. Press Ctrl+H to open the Find and Replace dialog. Type the header name in the Find what field and leave the Replace with field empty. Click Find All.

Excel will highlight every cell that contains that text. If the same header name appears in two or more columns, you have found your duplicates. Close the dialog and look at the highlighted cells to see which columns have the same header. Then delete the columns you do not need.

This method is useful when you have a large spreadsheet and scanning visually would take too long. However, it only finds duplicate headers, not duplicate data. If your duplicate columns have different header names but the same data, you will need to compare them manually.

Preventing duplicate columns when you import data

Duplicate columns often appear when you copy data from another source or import a file. Before you paste data into Excel, check the source file to see whether it already contains the columns you need. If you are copying from another Excel file, open both files side by side and compare the column headers before you paste.

When you import data using the Get Data feature (in the Data tab), Excel shows you a preview of the data before it enters your spreadsheet. Review this preview to make sure you are not importing columns that already exist in your sheet. If you see duplicates in the preview, you can cancel the import and adjust the source file instead.

If you regularly work with data from the same source, take a moment to document which columns you actually need. This prevents you from importing the same columns twice in future updates.

What to do if you accidentally delete the wrong column

If you delete a column and realize it was not a duplicate, press Ctrl+Z when ready. This undo command will restore the column as long as you have not performed any other actions since the deletion. If you have already made other changes, undo will reverse those changes too, so you may need to redo some work.

If you have already closed the file without saving, the deletion is permanent. Excel does not keep a backup of unsaved changes. This is why it is a good idea to save your file before you start deleting columns, then save again after you have confirmed the deletions were correct.

Frequently Asked Questions

Can I undo a column deletion after I have closed the file?

No. Once you close the file without saving, the deletion is permanent. Excel does not keep automatic backups of unsaved changes. If you have a backup copy of the file from before the deletion, you can open that instead.

What if two columns have the same data but different header names?

They are still duplicates if the data in every row is identical. Compare the columns side by side to confirm, then delete the one you do not need. The header name does not matter — what matters is whether the information is the same.

How do I know if a column is a duplicate or just similar?

Scroll through both columns and compare several rows. If every single row matches exactly, the column is a duplicate. If even one row differs, the columns are not duplicates and both should stay. When in doubt, keep the column until you are certain.

Can I delete multiple non-adjacent columns at the same time?

Yes. Hold Ctrl and click the header letter of each column you want to delete. All selected columns will highlight. Right-click and select Delete. All selected columns will be removed at once, even if they are not next to each other.

What happens to formulas that reference a deleted column?

Any formula that references a deleted column will show a #REF! error. Before you delete a column, search your spreadsheet for formulas that use it. You can use Ctrl+H to find the column letter in formulas, or review the formula bar when you click each cell. Update or delete those formulas before you remove the column.