• 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
28
250 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
  • Windows Server 2022 Remote Desktop Services User Connections (50) Cal Key Global Windows Server 2022 Remote Desktop Services User Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $22.00
  • AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 2 Years AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 2 Years
    Rated 5.00 out of 5
    $47.00
  • Avast Premium Security 2021 10 Devices 1 Year Global Avast Premium Security 2021 10 Devices 1 Year Global
    Rated 5.00 out of 5
    $28.00
  • Avast Ultimate Suite 2021 3 Years 10 Devices Global Avast Ultimate Suite 2021 3 Years 10 Devices Global
    Rated 5.00 out of 5
    $90.00
  • Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $22.00
Products
  • Microsoft Visio 2019 Professional Key Global Microsoft Visio 2019 Professional Key Global - 5 PC
    Rated 4.93 out of 5
    $19.00
  • Microsoft Office Home And Business 2016 For Mac Key Global Bind Microsoft Account Microsoft Office Home And Business 2016 For Mac Key Global Bind Microsoft Account
    Rated 4.92 out of 5
    $15.00
  • Kaspersky Plus - 1 Device 1 Year - GLOBAL Kaspersky Plus - 1 Device 1 Year - GLOBAL $23.00
  • Project Professional 2024 Project Professional 2024 $33.00
  • Windows Server 2019 Remote Desktop Services Device Connections (50) Cal Key Global Windows Server 2019 Remote Desktop Services Device Connections (50) Cal Key Global
    Rated 4.72 out of 5
    $20.00
  • Windows Server 2022 Standard Key Global Windows Server 2022 Standard Key Global
    Rated 4.10 out of 5
    $7.00
  • Project Standard 2021 Microsoft Project Standard 2021 - 1 PC $13.00
  • Microsoft Visual Studio 2019 Professional Key Microsoft Visual Studio 2019 Professional Key
    Rated 4.84 out of 5
    $15.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
  • Visio Professional 2024 Visio Professional 2024 $33.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.