Dose for Excel ribbon
“Editing” utilities » Delete columns
In the Excel menu choose: DOSE EDITING » Editing » Delete Columns

  1. Empty columns.
  2. At least one empty cell in column.
  3. With specified value.
  4. Identical columns.
  5. Hidden columns.

All of the above functions works for worksheet selection, current worksheet, or all worksheets at once.



 
 
2. At least one empty cell in column.

Save time of looking for rows having at least one blank cell in excel column wherever they are with one click will be deleted.
Three options to use the function with a selected range, current sheet or all sheets at once.
1. Empty columns

Save time and efforts looking for entire empty columns in excel worksheet wherever they are on the worksheet, find and delete them with one click.
Three options to use the function with a selected range, current sheet or all sheets at once.
 
3. With specified value.

Save time of looking for a certain value in columns to delete them wherever they are on with one click will be deleted.
Three options to use the function with a selected range, current sheet or all sheets at once.
 
4. Identical columns.

Save time of looking for identical values in columns to delete them wherever they are on with one click will be deleted.
Three options to use the function with a selected range, current sheet or all sheets at once.
 
5. Hidden columns.

Save time of looking for hidden column to delete them wherever they are on with one click will be deleted.
Three options to use the function with a selected range, current sheet or all sheets at once.
Up
Up
Up
Up
Up
delete columns
empty columns
empty columns results
at least one empty cell in column
at least one empty cell in column results
specified value in row
specified value in row results
identical columns
identical columns results
hidden columns
hidden columns results
Home

Copyright © 2014 - 2017 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.
Home