How Excel Bulk Delete

Source: Internet
Author: User
Tags one table ranges

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.