How to Delete Column B from Every Excel Worksheet
Question details
The user wants to remove column B from all worksheets in an Excel workbook simultaneously, or keep only column B while deleting all other columns.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Managing multi-sheet workbooks where uniform column deletion is required to standardize formatting, clean up data, or streamline the layout across the entire file.
- Observed behavior
- Deleting columns individually sheet by sheet is time-consuming. Users need a bulk method via UI grouping or VBA to process all worksheets at once efficiently.
Always save a backup copy of your workbook before deleting columns across multiple sheets or running VBA macros, as these bulk actions cannot always be easily undone.
Delete a Column Across All Worksheets Using Sheet Grouping
Group all worksheets together to perform the deletion once, automatically applying the change to the entire workbook simultaneously.
Right-click on any worksheet tab at the bottom of the Excel window and select "Select All Sheets" from the context menu. The tabs will turn white to indicate they are grouped.
Click the column header letter (e.g., "B") to highlight the entire column you wish to delete.
Right-click the selected column header and choose "Delete" from the drop-down menu. The column will instantly be removed from all grouped worksheets.
Right-click any sheet tab at the bottom and select "Ungroup Sheets" to resume normal, single-sheet editing mode.

Use VBA Macros to Delete Specific Columns from All Sheets
Utilize Visual Basic for Applications (VBA) to automate the deletion of Column B, or delete all other columns to keep only Column B.
Use WPS Spreadsheet to Quickly Delete Columns Across Worksheets
WPS Spreadsheet fully supports sheet grouping and VBA macros, allowing you to seamlessly delete columns across all worksheets just like in Microsoft Excel. It's a lightweight, highly compatible, and free alternative for all your data processing needs.
- 1. Open your workbook in WPS Spreadsheet: Launch WPS Office and open your multi-sheet spreadsheet file.
- 2. Group the worksheets: Right-click any sheet tab at the bottom and click "Select All Sheets".
- 3. Delete the column: Right-click the column letter (e.g., Column B) and choose "Delete" to remove it from all sheets at once.
- 4. Ungroup the sheets: Right-click a sheet tab and click "Ungroup Sheets" to return to single-sheet editing mode.

Frequently Asked Questions
Can I undo the deletion if I accidentally remove the wrong column from all sheets?
If you used the manual "Select All Sheets" grouping method, you can generally press Ctrl + Z to undo the deletion immediately. However, if you used a VBA macro, the action cannot be undone, which is why saving a backup beforehand is crucial.
How do I delete multiple non-adjacent columns from every worksheet?
First, group all your sheets by right-clicking a tab and selecting "Select All Sheets". Next, hold down the Ctrl key while clicking the headers of the non-adjacent columns you want to delete. Finally, right-click any of the highlighted headers and choose "Delete".
Why is the "Delete" option grayed out when I group my sheets?
This usually happens if the workbook or specific worksheets are protected. You will need to unprotect the sheets by going to the Review tab and selecting "Unprotect Sheet" (entering a password if prompted) before you can modify the columns.
Will deleting a column across all sheets affect my charts or formulas?
Yes, deleting a column will shift remaining data to the left. If your charts or formulas reference the deleted column or specific absolute cell addresses that get shifted out of bounds, they may return a #REF! error or display data incorrectly.




