Highlight or delete identical, empty, or hidden cell columns, or cell columns with a specific value, or cell columns with at least one empty cell column. The “Delete Columns” feature in Dose for Excel can help you save time and effort while working with large worksheets.
- Delete Empty columns
- Delete columns of at least one empty cell
- Delete columns With specified value
- Delete Identical columns
- Delete Hidden columns
- Click DOSE » Delete » Delete Columns



- Delete Empty Columns
- Check the option for “Empty columns” after selecting a range of cells.
- Then press the Apply button. The result will be as seen in the screenshot below.
- The range can be chosen from three options: selected range, current sheet, or all sheets.



- Delete columns of at least one empty cell
- Check the option “At least one empty cell in column” when selecting a range of cells.
- Then press the Apply button. The result will be as seen in the screenshot below.
- The range can be chosen from three options: selected range, current sheet, or all sheets.



- Delete Columns With Specified Value
- Check the “With Specified Value” option for a range of cells.
- Fill in the value, and any columns that contain it will be removed.
- Then press the Apply button. The result will be as seen in the screenshot below.
- We used the value “Accountant” in the example below.
- The range can be chosen from three options: selected range, current sheet, or all sheets.



- Delete Identical Columns
- Check the “Identical columns” option after selecting a range of cells.
- Then press the Apply button. All columns that are redundant or identical will be removed. The result will be as seen in the screenshot below.
- The range can be chosen from three options: selected range, current sheet, or all sheets.



- Check the “Hidden columns” option after selecting a range of cells.
- Then press the Apply button. All columns that are concealed will be removed. The result will be as seen in the screenshot below.
- The range can be chosen from three options: selected range, current sheet, or all sheets.



- Demo
More Features:
How to insert a date picker in Excel
Add Date Pickers to Your Excel Sheets in No Time Effortlessly streamline data entry and…
Excel Color Duplicates
Color Duplicated Cells Values In Groups In Excel Color the duplicated cells values, each group…
Excel Batch Delete Check Boxes
Excel Batch Delete Check Boxes In Excel Batch deleting check boxes in selected cells without…
How to Change Text Case In Excel
Change Case Of Excel Cells Text Change case of text in selected cells in Excel…
How To Color Alternate Row In Excel
Color alternate row or column in Excel With this utility you can quickly apply shading…
Excel Extend Selection To The Last Used Column
Easily Extend Selection To The Last Used Column Normally if you want to select a…