Find and replace operations for Excel

Source: Internet
Author: User
Tags range

Finding and replacing is an operation that is often performed during editing, and in Excel, in addition to finding and replacing text, you can find and replace formulas and notes, which are more widely used and further improve the efficiency of editing processing. With these features, we can quickly find cells that have special characters in all worksheets except the Visual Basic module. We can replace existing characters with another string of characters in all cells in a worksheet, in one selection on a worksheet, or in the current selection of a worksheet or worksheet group. You can also find and select cells that have similar content.

5.6.1 Lookup Command

When you need to review or modify portions of a worksheet, you can find and replace any specified values, including text, numbers, dates, or find a formula, a note. For example, we can specify that Excel finds only special text with some uppercase format. For example, you can look for "green" instead of looking for "green".

To perform a lookup operation, follow these steps:

(1) Perform the "Find" command on the Edit menu, and the screen displays a dialog box, as shown in Figure 5-18.

(2) In the Find What box, enter the string you want to find, and then specify the search by and search scopes, and then press the Find Next button to start looking for work.

(3) When Excel finds a matching content, the cell pointer points to the cell. Then we can decide what to do next, and if we need to find it further, we can select and press the "Find Next" button, or you can choose the "Close" button to exit the Lookup dialog box.

Tip: You can enter up to 255 English characters (one Chinese character equals two letters) in the search target. Because the lookup target box can display a few words, when we enter a string that exceeds its display range, Excel automatically scrolls the string to display the data over the range. We can also scroll the string by moving the cursor.

Excel also provides a lookup of formulas and notes.

Tip: If you want to perform a find or replace work on a worksheet, you can select it as a worksheet group before you perform the appropriate action.

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.