Home | Products |Purchase | FAQ | Contact Us | Useful Resources

Excel Tool Delete Blank, Hidden Rows, Columns, Sheets

The software can delete blank rows, hidden rows, visible rows, blank columns, hidden columns, blank sheets, hidden sheets, also can delete user-specified characters, spaces, digital, and so on. It worked smoothly and quickly, even with large worksheets, thereby saves your time. It is very simple to use.

With the software you may:

Delete blank rows from your Excel

Delete hidden rows from your Excel.

Delete visible rows from your Excel.

Delete blank columns from your Excel

Delete hidden columns from your Excel

Delete visible columns from your Excel.

Delete blank sheets from your Excel

Delete hidden sheets from your Excel

Delete All The Text Before Character Position

Delete All The Text After Character Position

Delete User-Defined Characters

Delete All The Text Before User-Defined Character

Delete All The Text After User-Defined Character.

Delete Cells Having User-Defined Character.

Delete Cells Not Having User-Defined Character..

Delete Extra Spaces Character At Begin

Delete Letter Characters from your Excel.

Delete Digital Characters from your Excel.

Current Version: 10.5.18
File Size: 1.64(MB)
Platform: Windows2000/XP/Vista/Windows7.
Software requirements: Microsoft Excel 97/2000/XP/2003/2007 or higher.
Purchase Price: $18.95

Delete blank rows from your Excel

First select a row or range.

For Office 2007. Open "Add-Ins" tab and menu " Delete > Delete Blank Rows "

For Office 2000/XP/2003. open menu " Delete > Delete Blank Rows "

Click "OK" Button

Result is

Delete blank columns from your Excel

First select a single cell or range

Open menu " Delete > Delete Blank Columns "

Click "OK" Button

Result is: Blank Column "State" and "Quantity" have been deleted.

Delete hidden columns from your Excel

Taking the "Delete_HiddenColumns" sheet for example:

"B" Columns and "D" Columns is hidden.

First select a single cell or range

Open menu "Delete > Delete Hidden Columns"

Result is: 2 hidden columns have been deleted!

Delete Blank Sheets and Hidden Sheets

Open menu "Delete > Delete Sheets ..."

Select an option in "Option Delete":

Select 'Delete Blank Sheets' option in "Option Delete", will delete blank sheets.

Select 'Delete Hidden Sheets' option in "Option Delete", will delete hidden sheets.

Delete All The Text Before Character Position

Select a range of cells.

Open menu "Delete > Complex Delete (Selected Cells) > Delete All The Text Before Character Position"

Enter Character Position, and will delete all the text before it:

Result is:

Delete All The Text After Character Position

Select a range of cells.

Open menu "Delete > Complex Delete (Selected Cells) > Delete All The Text After Character Position"

Enter Character Position, and will delete all the text after it:

Result is:

Delete User-Defined Characters

Select a range of cells.

Open menu "Delete > Complex Delete (Selected Cells) > Delete User-Defined Characters"

Enter the characters that you want to delete:

Result is: Character "X" have been deleted

Delete All The Text Before User-Defined Characters

Select a range of cells

Open menu "Delete > Complex Delete (Selected Cells) > Delete All The Text Before User-Defined Character"

Enter the character which you want to delete all characters before it:

Result is:

Delete Extra Spaces Character At Begin

Select a range of cells

Open menu "Delete > Complex Delete (Selected Cells) > Delete Extra Spaces Character At Begin"

Result is: