How to delete multiple Excel files at once

How to quickly delete multiple sheets in ExcelWorking with sheets in Excel involves the very basics of working with Excel tables. With an Excel sheet we have operations like adding

How to delete multiple Excel files at once

How to quickly delete multiple sheets in Excel

Working with sheets in Excel involves the very basics of working with Excel tables. With an Excel sheet we have operations like adding sheets, changing sheet colors or deleting sheets when not in use.

  • How to print multiple sheets at once in Excel spreadsheets
  • How to print multiple sheets in Excel

The sheet deletion operation basically just press Delete to delete. However, if you need to delete multiple sheets then the traditional way of deleting each sheet is relatively time-consuming and unprofessional. The following article will guide you to read 2 ways to delete multiple sheets in Excel.

1. How to delete multiple Excel sheets by Ctrl

To delete a sheet in Excel , just right-click on the sheet you want to delete and select Delete .Picture 1 of How to quickly delete multiple sheets in Excel

If you want to delete multiple sheets at the same time , we press and hold the Ctrl key, then click the sheets you want to delete, right-click and choose Delete .Picture 2 of How to quickly delete multiple sheets in Excel

Alternatively, you can also right-click a sheet and select Select All Sheets to select all the sheets .Picture 3 of How to quickly delete multiple sheets in Excel

Hold down the Ctrl key and click on the sheets you don't want to delete , and then press Delete to delete the rest.Picture 4 of How to quickly delete multiple sheets in Excel

Instructions for deleting multiple Excel sheets with Macros code

Besides the traditional delete Excel sheet above, we can also use Macros to delete multiple sheets at once.

Step 1:

You do not want to separate the sheet names you want to delete from other sheets. Then press Alt + F11 to launch Microsoft Visual Basic for Applications. Then click Insert> Module .Picture 5 of How to quickly delete multiple sheets in Excel

Step 2:

Next you enter the code below into the interface.Public Sub Test() Application.DisplayAlerts = False Dim Ws As Worksheet For Each Ws In Worksheets If Ws.Name <> "Test" Then Ws.Delete Next Ws Application.DisplayAlerts = True End Sub

Here Test is the sheet you want to keep in the Excel table.Picture 6 of How to quickly delete multiple sheets in Excel

Step 3:

Continue to click Run to run the code in Excel.Picture 7 of How to quickly delete multiple sheets in Excel

Resulting all sheets in the data file have been deleted, except for the Test sheet that we entered in the code.Picture 8 of How to quickly delete multiple sheets in ExcelUpdate 14 December 2020« PREVNEXT »Read more

  • MS Excel - Lesson 4: Working with lines, columns, sheets
  • How to add rows and delete rows in Excel
  • How to merge multiple sheets into 1 PDF file in Excel 2013
  • Summary of data from multiple Sheets in Excel
  • Tricks using Google Sheets should not be ignored
  • List of common shortcuts for Google Sheets on Chrome OS (Part 3)
  • How to delete dots in a series of numbers on Excel
  • How to count on multiple sheets of Google Sheets
  • How to convert Excel file to Google Sheets
  • Create a table of contents for a list of worksheets in ExcelMaybe you are interested
  • How to change dots into commas on Google Sheets
  • How to convert A4 size prints to A3 size in Word
  • How to fix Office error 'The function you are attempting to run contains macros'
  • How to delete dots in a series of numbers on Excel
  • How to backup and restore the Office license key for all versions
  • How to Convert Excel to Dat
  • How to align 2-sided printing in Word is symmetrical
  • How to adjust line spacing and line spacing in Excel

Video liên quan