Insert and Delete Columns in Excel: Step-by-Step

This guide shows you exactly how to insert and delete columns in Microsoft Excel, helping you reorganize your spreadsheet without breaking formulas or losing data. You’ll learn the fastest methods, common pitfalls, and how to fix things when a column won’t delete or your formulas go haywire.

What You’ll Need

• A computer with Microsoft Excel installed (any recent version, including Excel 365, 2021, 2019, or earlier).
• An existing spreadsheet with data you want to modify.
• Basic familiarity with selecting cells and using the mouse or keyboard.

Step-by-Step

How to Insert a Column

1. Select the column to the right of where you want the new column. For example, to insert a column between columns B and C, click on the letter C at the top of the column. This highlights the entire column.
2. Right-click the selected column header (the letter). A context menu appears.
3. Click “Insert” from the menu. Excel immediately adds a new column to the left of the one you selected. The new column takes the letter of the column you clicked, and the original column (and everything to its right) shifts one position.
4. Alternative method using the Ribbon: Select the column, go to the Home tab, find the Cells group, click the Insert dropdown arrow, and choose Insert Sheet Columns.
5. Keyboard shortcut: Select the column and press Ctrl + Shift + + (plus key) on Windows, or Cmd + Shift + + on Mac. This opens a small dialog asking if you want to shift cells right or insert an entire column—choose “Entire column” and click OK.
6. Insert multiple columns at once: Select the same number of columns as you want to insert (e.g., select columns C and D to insert two new columns), then right-click and choose “Insert.” Excel inserts that many new columns to the left of your selection.

How to Delete a Column

1. Select the column(s) you want to delete by clicking the letter header. To delete multiple adjacent columns, click and drag across the letters, or hold Ctrl and click each letter.
2. Right-click the selected column header and choose Delete from the context menu. The column is removed, and all columns to the right shift left to fill the gap.
3. Alternative via Ribbon: With the column selected, go to Home > Delete dropdown > Delete Sheet Columns.
4. Keyboard shortcut: Select the column and press Ctrl + – (minus key) on Windows, or Cmd + – on Mac. Choose “Entire column” in the dialog and click OK.
5. Undo if you make a mistake: Press Ctrl + Z (or Cmd + Z on Mac) immediately after deleting to restore the column and its data.

Common Mistakes

• Deleting the wrong column: It’s easy to misclick and delete a column with important data. Always double-check the column letter before right-clicking.
• Inserting instead of deleting (or vice versa): The context menu options are close together; make sure you choose the correct action.
• Not selecting the entire column: If you only select a few cells, Excel may ask whether to shift cells or insert rows/columns. This can lead to unexpected results, like shifting only a portion of your data.
• Forgetting about formulas: Deleting a column that is referenced by formulas in other cells can cause #REF! errors. Excel does not automatically adjust formulas when you delete a column—it removes the reference entirely.
• Deleting columns with hidden data: If a column is hidden, you might not see it, but it still exists. Deleting an adjacent column won’t remove the hidden one, and you might accidentally delete data you didn’t realize was there.

Tips

• Use the “Insert” and “Delete” buttons on the Ribbon if you prefer not to right-click. They are located in the Cells group on the Home tab.
• To insert a column without disturbing data in other columns, select a cell in the column to the right, then use “Insert” > “Insert Sheet Columns.” This still shifts the entire column, but it’s faster if you’re already working in that area.
• If you need to insert many columns, select multiple columns first—Excel will insert that many new ones in one go.
• Use the “Format Painter” or copy formatting from an existing column to the new one if you want it to match (e.g., borders, number formats).
• Before deleting a column, check for any formulas that reference it. Use Ctrl + ~ (tilde) to show formulas, or use “Trace Dependents” under the Formulas tab to see which cells rely on that column.

Troubleshooting

• “Insert” or “Delete” is grayed out: This usually happens when the sheet is protected. Go to Review > Unprotect Sheet (you may need a password). Also, check if the workbook is shared—unshare it from Review > Share Workbook.
• You get a “This action won’t work on multiple selections” error: This occurs when you select non-adjacent columns and try to delete them. Select adjacent columns only, or delete them one at a time.
• Deleting a column causes #REF! errors in formulas: Undo the deletion (Ctrl+Z), then edit the formulas to remove references to that column before deleting again. Alternatively, replace the formula with static values if you no longer need it.
• Inserting a column pushes data off the edge of the sheet: Excel won’t allow inserting a column if it would push data beyond column XFD (the last column). If you see an error, you have data in the last column—move or delete it first.
• New column doesn’t show the same formatting as the rest: Excel usually copies formatting from the column to the left, but if you have inconsistent formatting, manually apply the desired format using the Format Painter.
• Column won’t delete because the sheet is in “Page Break Preview” mode: Switch back to “Normal” view (View tab > Normal) and try again.

Frequently Asked Questions

Can I insert a column without affecting the rest of the sheet?

No, inserting a column always shifts the entire column to the right. If you only want to add data to a specific area, consider adding a new worksheet or using a table.

What happens to formulas when I insert a column?

Excel automatically adjusts most formulas when you insert a column, updating cell references to reflect the new layout. For example, if a formula references C2 and you insert a column before C, the formula changes to D2. However, formulas that reference entire columns or use indirect references may need manual adjustment.

How do I delete multiple columns at once?

Select the columns by clicking and dragging across their letters (or hold Ctrl and click each), then right-click and choose Delete. Excel removes all selected columns in one action.

Can I undo an accidental column deletion?

Yes, press Ctrl+Z (or Cmd+Z on Mac) immediately after the deletion. If you’ve done other actions since, you may need to undo multiple steps, but Excel’s undo history usually covers recent changes.

Why does Excel say “This action won’t work on multiple selections” when I try to delete columns?

This happens when you select non-adjacent columns (e.g., columns A and C) and try to delete them together. Excel only allows deleting adjacent columns in a single operation. Select adjacent columns or delete them one by one.

Is there a way to insert a column using only the keyboard?

Yes: select the column (click the letter), then press Ctrl+Shift+Plus (+). On a Mac, use Cmd+Shift+Plus. If you have a laptop without a dedicated plus key, use the one on the number pad or press the plus with Shift.

Related

• iPhone Camera Freezing? Fixes That Work
• Microsoft Edge Status Invalid Image Hash Error Fix
• How to Sell Payroll Services