PlayInfoBox

Home /Utilities /How to Add or Delete Multiple Excel Sheets at Once

How to Add or Delete Multiple Excel Sheets at Once

Selecting sheet tabs together lets you add or remove several sheets in one move instead of repeating the same right-click menu over and over.

  1. Select several existing sheet tabs

    Hold Ctrl (Cmd on Mac) and click each sheet tab you want to use as a starting point, selecting as many as the number of new sheets you need.

  2. Right-click the selection and choose Insert

    Right-click any of the selected tabs and choose Insert -- Excel adds that same number of new sheets in one action.

  3. Select several sheet tabs to remove

    Hold Ctrl and click each sheet tab you want to delete to select them all together.

  4. Right-click the selection and choose Delete

    Right-click the selected tabs and choose Delete -- all of the selected sheets are removed at once.

  5. Why this is worth knowing

    Whether you're setting up twelve monthly sheets or clearing out ones you no longer need, selecting multiple tabs first saves you from repeating the same click sequence over and over.

Working with tabs instead of one sheet at a time

Most people learn to add or delete Excel sheets one at a time, right-clicking a single tab and choosing Insert or Delete each time. Once a workbook needs several new sheets -- one per month, one per region, one per project phase -- that habit turns into a lot of repetitive clicking. Selecting the tabs first changes the scope of a single Insert or Delete command to match how many tabs are selected, so the same two clicks handle five sheets as easily as one.

A quick note on undo

Deleting a sheet in Excel usually can't be undone with Ctrl+Z the way most other actions can, and this is especially easy to forget when deleting several sheets in one action. Before right-clicking Delete, it's worth double-checking that every selected tab is genuinely something you no longer need, since recovering a deleted sheet afterward may not be possible.

Frequently Asked Questions

Can I select sheet tabs that aren't next to each other?

Yes -- holding Ctrl and clicking each tab individually lets you select tabs that are scattered across the tab bar, not just ones sitting next to each other.

Is there a way to undo a sheet deletion?

Not reliably. Excel's undo history often doesn't cover sheet deletion, so it's safer to keep a backup copy of the workbook before deleting sheets you're not fully sure about.