1. Delete blank rows or columns
You can delete all blank rows from a selection, the current worksheet, the selected worksheet, or all worksheets. If you have more than one table in your workbook that may have empty rows, it is time-consuming to delete them one at a time, and you can use this feature to help you solve the empty line problem.
Action method:
Click Bulk deletion → delete blank rows or columns in the cells and Ranges group, and then open the Delete Row or Column dialog box.
Goal:
• Blank lines: Rows with no content, including only formatted rows, such as colors, fonts, and so on.
• Blank columns: Columns with no content, including only formatted columns, such as color, font, and so on.
Range:
• Current sheet: A worksheet that is currently displayed on a computer screen and remains active.
• Current workbook: A workbook that is displayed at the time on the screen and at least one worksheet that is active.
Attention:
• In this range, the protected worksheet will be ignored.
• Include hidden worksheets, do not ignore deep hidden worksheets, please proceed with caution.
Selection: Select the range of cells you want to delete by yourself.
2. Unlink Hyperlinks
Often downloaded from the network you will find that the document will have hyperlinks, one of the manual cancellation is very troublesome, using the use of easy to remove the hyperlink function, can be very quick to help you solve this problem.
Action method:
Click bulk delete → unlink hyperlink in the cells and Ranges group to open the Unlink Hyperlink dialog box.
Range:
• Current sheet: A worksheet that is currently displayed on a computer screen and remains active.
• Current workbook: A workbook that is displayed at the time on the screen and at least one worksheet that is active.
Selection: Select the range of cells you want to delete by yourself.
Attention:
• This feature is not valid for formulas that use hyperlinks, such as: HYPERLINK.
• Include hidden worksheets, do not ignore deep hidden worksheets, please proceed with caution.
3. Delete objects
In Excel, you can use the keyboard or key combination to locate objects, and then delete them one at a time, but you need to delete some objects and keep some other objects, this method is no longer applicable, the use of Easy-to-use Treasure Delete Object function, you can achieve the perfect effect.
Action method:
Click Bulk delete → delete objects in the cells and Ranges group to open the Delete Object dialog box.
Range:
• Current sheet: A worksheet that is currently displayed on a computer screen and remains active.
• Current workbook: A workbook that is displayed at the time on the screen and at least one worksheet that is active.
Attention:
Contains hidden worksheets and does not ignore deeply hidden worksheets, please proceed with caution.
Selection: Select the range of cells you want to delete by yourself.