• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

Tip for easily deleting multiple Excel sheets at once

0 Comments

Tip for easily deleting multiple Excel sheets at once: Deleting sheets is a common task when working with Excel spreadsheets. If you need to delete a few sheets, you can do it manually. However, deleting dozens or even hundreds of sheets (to keep the spreadsheet tidy) can be a big problem if done the usual way. Please follow the article below to learn how to delete multiple Excel sheets at once.

1. Delete multiple Excel sheets at once by grouping sheets

Usually, to delete an Excel sheet, we just need to right-click on that sheet and select Delete.

Tip for easily deleting multiple Excel sheets at once

Tip for easily deleting multiple Excel sheets at once

If you want to delete multiple sheets at once, you just need to hold down the Ctrl key and select all the sheets you want to delete to group them into a group. Then right-click on any sheet and select Delete. That way, all the selected sheets will be quickly deleted.

Tip for easily deleting multiple Excel sheets at once

Tip for easily deleting multiple Excel sheets at once

Or if you want to delete all sheets in the file, you just need to group all sheets in the file into a group by right-clicking on any sheet and selecting Select All Sheets. Then right-click and select Delete as above to easily delete all sheets in the file.

Tip for easily deleting multiple Excel sheets at once

Tip for easily deleting multiple Excel sheets at once

2. Delete multiple sheets at once with VBA code

With this method, you can delete all sheets in your Excel file except for those named GPE. So you need to name GPE for the sheets you want to keep in your Excel file. Then, you select the Developer tab => Visual Basic or press the Alt + F11 shortcut to open Microsoft Visual Basic for Applications.

Tip for easily deleting multiple Excel sheets at once

Tip for easily deleting multiple Excel sheets at once

In the VBA window, select Insert => Module.

Tip for easily deleting multiple Excel sheets at once

Tip for easily deleting multiple Excel sheets at once

Then, copy the following code into the Module dialog box:

Public Sub GPE()
Application.DisplayAlerts = False
Dim Ws As Worksheet
For Each Ws In Worksheets
If Ws.Name <> "GPE" Then Ws.Delete
Next Ws
Application.DisplayAlerts = True
End Sub

Then click Run or press F5 to run the code. That way, Excel sheets without the name GPE will be quickly deleted.

Tip for easily deleting multiple Excel sheets at once

Tip for easily deleting multiple Excel sheets at once

So, the article above has guided you on how to delete multiple Excel sheets at once. Hopefully, the article will be useful to you in your work. Good luck!

Rate this post
37
257 Views
How to Copy a Chart from Excel to WordPrevHow to Copy a Chart from Excel to WordMarch 24, 2023
How to limit the working area in ExcelMarch 24, 2023How to limit the working area in ExcelNext

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • AVG Internet Security 2021 1 Device 1 Year Global AVG Internet Security 2021 1 Device 1 Year Global
    Rated 5.00 out of 5
    $11.00
  • Buy Office 2021 Professional Plus Key Global For 5 PC Buy Office 2021 Professional Plus Key Global For 5 PC
    Rated 5.00 out of 5
    $68.00
  • Avast SecureLine VPN 2021 2 Years 5 Devices Global Avast SecureLine VPN 2021 2 Years 5 Devices Global
    Rated 5.00 out of 5
    $47.00
  • Windows 11 Pro Product Activation Key Windows 11 Pro Product Activation Key
    Rated 5.00 out of 5
    $6.00
  • AVG Internet Security 2021 10 Devices 1 Year Global AVG Internet Security 2021 10 Devices 1 Year Global
    Rated 5.00 out of 5
    $30.00
Products
  • Windows 10 Pro OEM Key Global - Reinstalling win is still active Windows 10 Pro OEM Key Global - Reinstalling win is still active
    Rated 4.88 out of 5
    $6.00
  • Kaspersky Plus - 1 Device 1 Year - GLOBAL Kaspersky Plus - 1 Device 1 Year - GLOBAL $23.00
  • Visio Professional 2024 Visio Professional 2024 $33.00
  • Microsoft Visio Professional 2010 Key 1PC Microsoft Visio Professional 2010 Key 1PC $9.00
  • AVG Internet Security 2021 10 Devices 1 Year Global AVG Internet Security 2021 10 Devices 1 Year Global
    Rated 5.00 out of 5
    $30.00
  • Windows Server 2019 Remote Desktop Services 50 USER Connections Key Global Windows Server 2019 Remote Desktop Services 50 USER Connections Key Global
    Rated 4.75 out of 5
    $20.00
  • Office 2019 Professional Plus Key Global Bind to your Microsoft Account Office 2019 Professional Plus Key Global Bind to your Microsoft Account
    Rated 4.97 out of 5
    $49.00
  • Microsoft Visual Studio Enterprise 2022 For 1 PC Microsoft Visual Studio Enterprise 2022 For 1 PC $19.00
  • Windows 10 Enterprise Key Global Windows 10 Enterprise Key Global
    Rated 4.82 out of 5
    $9.00
  • Windows Server 2025 Standard Windows Server 2025 Standard $30.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.