Document Editing Problems

How to Delete Column B from Every Excel Worksheet

Steven ParkerSteven Parker Nov 3, 2026 870 views

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.

How to Delete the Same Column from Every Excel Worksheet
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.
Before you start

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.

Solution 1Recommended

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.

1
Select all sheets

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.

2
Select the target column

Click the column header letter (e.g., "B") to highlight the entire column you wish to delete.

3
Delete the column

Right-click the selected column header and choose "Delete" from the drop-down menu. The column will instantly be removed from all grouped worksheets.

4
Ungroup the sheets

Right-click any sheet tab at the bottom and select "Ungroup Sheets" to resume normal, single-sheet editing mode.

Delete a Column Across All Worksheets Using Sheet Grouping
Manage Multi-Sheet Data Efficiently

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. 1. Open your workbook in WPS Spreadsheet: Launch WPS Office and open your multi-sheet spreadsheet file.
  2. 2. Group the worksheets: Right-click any sheet tab at the bottom and click "Select All Sheets".
  3. 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. 4. Ungroup the sheets: Right-click a sheet tab and click "Ungroup Sheets" to return to single-sheet editing mode.
100% compatibility with Microsoft Excel (.xlsx, .xls) and macros (.xlsm)Intuitive sheet grouping feature for fast multi-sheet editingFree, lightweight, and fast-loading spreadsheet editorBuilt-in advanced data tools for complex workbook management
microsoft office alternative - wps office

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.