Excel How to Delete Empty Columns
Copyright © 2014 - 2021 Zbrainsoft.com | All Rights Reserved. Sitemap
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Highlight Or Delete Any Type Of Columns
Highlight or delete identical, or empty, or hidden, or with specified value, or with at least one empty cell columns. Dose for Excel's Delete Columns utility can save you time and effort working on huge worksheets.
- Click DOSE » Delete » Delete Columns
- Delete Empty Columns
1. Select range of cells and check Empty columns option.
2. Then click Apply. You will see the result as shown in the below screenshot.
Three options to select the range: selected range, current sheet or all sheets.
- Delete Columns With Specified Value
1. Select range of cells and check With Specified Value option.
2. Fill in the box the value, all columns contains this value will be deleted.
3. Then click Apply. You will see the result as shown in the below screenshot.
In below example, we specified a value "Accountant".
Three options to select the range: selected range, current sheet or all sheets.
- Delete columns of at least one empty cell
1. Select range of cells and check At least one empty cell in column option.
2. Then click Apply. You will see the result as shown in the below screenshot.
Three options to select the range: selected range, current sheet or all sheets.
- Delete Identical Columns
1. Select range of cells and check Identical columns option.
2. Then click Apply. All duplicated or identical columns will be deleted. You will see the result as shown in the below screenshot.
Three options to select the range: selected range, current sheet or all sheets.
- Delete Hidden Columns
1. Select range of cells and check Hidden columns option.
2. Then click Apply. All hidden columns will be deleted. You will see the result as shown in the below screenshot.
Three options to select the range: selected range, current sheet or all sheets.
Dose for Excel adds more than +100 new features and functions to your Excel.
Supported Excel versions: 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 14 days.
- Demo
