How to Delete Multiple Columns in Excel: Bulk Selection Technique

I spent years watching colleagues delete Excel columns one by one. There’s a better way to remove dozens at once without the tedious clicking.

The technique uses shift-click to select ranges instantly, then one keystroke deletes them all. Works in every modern Excel version I’ve tested, from Office 365 to Excel 2016. No special permissions or add-ins required.

You’ll clear entire data ranges in seconds instead of minutes, even with protected sheets. The method scales whether you’re removing five columns or fifty.

Between you and me, this saved me hours during quarterly reporting at Microsoft. The trick is in the selection, not the deletion.

What Youll Need

Instructions

Here’s the procedure I use to remove multiple columns quickly and accurately in any spreadsheet.

First, I click the header of the first column I want to remove. Then I hold down the Shift key and click the header of the last column in the range. This selects all columns in between, including both endpoints. If the columns aren’t contiguous, I’ll use a different approach.

Watch for the highlighted column headers to confirm the entire range is selected. The active cell will show the range, like A:D, in the name box at the top left of the sheet. If the range looks wrong, I release the Shift key and try again.

With the columns highlighted, I right-click any of the selected headers and choose Delete from the context menu. Alternatively, I can use the Ctrl + – keyboard shortcut (the minus sign on the numeric keypad won’t work—use the one on the main keyboard).

The columns disappear immediately, and the remaining columns shift left to fill the gap. I always double-check that the correct columns were removed by verifying the data in the adjacent columns. If I accidentally delete the wrong range, I press Ctrl + Z to undo.

For non-adjacent columns, I use the name box to the left of the formula bar. I type the exact range, like A:A,D:D,F:F, to select multiple individual columns. Each column header will highlight as I type, confirming the selection.

Once selected, I right-click and choose Delete or use Ctrl + – as before. This method works for any combination of columns, no matter how spread out they are. I verify the sheet afterward to ensure no unintended columns were affected.

Another method I rely on is the ribbon. After selecting the columns, I go to the Home tab, click the Delete dropdown in the Cells group, and choose Delete Sheet Columns. This is especially useful when working with a mouse-heavy workflow.

The action is immediate, so I always pause to confirm the selection before clicking. If I’m working with a large dataset, I save the file first—just in case. The undo feature is reliable, but prevention is better than recovery.

After deleting, I scan the sheet for any gaps or misaligned data. Formulas referencing the deleted columns will now show #REF! errors, so I check dependent cells and update references as needed.

I also ensure that any tables or named ranges still function correctly. If I deleted columns within a table, Excel usually adjusts the table range automatically, but I confirm this by checking the table’s resize handles. Everything should look seamless, as if those columns were never there.

Tips and Common Mistakes

These insights will help you avoid the most common pitfalls when working with spreadsheet columns.

Selection Precision: In Step 1, always verify your range in the name box before proceeding. I’ve seen too many spreadsheets ruined by accidental selections—especially when working with large datasets. The name box at the top left shows exactly what you’re about to delete, like A:D, so use it as your final check.

The Undo Lifeline: Step 2 mentions using Ctrl + Z to undo mistakes, and I can’t emphasize this enough. Make it muscle memory. The moment you realize something went wrong, hit that combination immediately. Excel’s undo history is surprisingly deep, but it won’t save you if you close the file first.

Non-Contiguous Caution: For Step 3, when typing ranges like A:A,D:D,F:F in the name box, go slowly. It’s easy to mistype a colon as a comma, which will either select nothing or the wrong columns entirely. Each column header should highlight as you type—if it doesn’t, start over.

Post-Deletion Verification: Step 5’s advice about checking for #REF! errors is critical. These errors won’t always be obvious, especially in complex spreadsheets with multiple sheets. After deletion, scan not just the current sheet but any that might reference the removed columns.

Frequently Asked Questions

Now that you’ve mastered the bulk deletion trick, removing multiple columns in Excel is a breeze! 🌟 Whether you prefer keyboard shortcuts, right-click menus, or the ribbon, you’re equipped to streamline your spreadsheets efficiently. Try practicing on a sample file to build confidence, and soon you’ll handle large datasets like a pro!