Dose for Excel ribbon
Delete rows
“Editing” utilities » Color / Delete rows
In the Excel menu choose: DOSE EDITING » Editing » Color / Delete Rows

You can highlight or delete rows for:

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

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


 
empty rows
empty rows results
 
2. At least one empty cell in row.

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

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

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

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

Save time of looking for hidden rows to delete them wherever they are on with one click will be highlighted or deleted.
Three options to use the function with a selected range, current sheet or all sheets at once.
Up
Up
Up
Up
Up
at least one empty cell in row
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