Discover or change textual content and numbers on a worksheet

Discover

To seek out one thing, press Ctrl+F, or go to Dwelling > Enhancing > Discover & Choose > Discover.

Notice: Within the following instance, we have chosen Choices >> to point out all the Discover dialog field. By default, it shows with Choices hidden.

1. Within the Discover what field, kind the textual content or numbers you need to discover, or choose the arrow within the Discover what field, after which choose a latest search merchandise from the listing.

   Suggestions: 

   • You should use wildcard characters — query mark (?), asterisk (*), tilde (~) — in your search standards.

   • Use the query mark (?) to seek out any single character — for instance, s?t finds “sat” and “set”.

   • Use the asterisk (*) to seek out any variety of characters — for instance, s*d finds “unhappy” and “began”.

   • Use the tilde (~) adopted by ?, *, or ~ to seek out query marks, asterisks, or different tilde characters  — for instance, fy91~? finds “fy91?”.

2. Choose Discover All or Discover Subsequent to run your search.

   Tip: Once you Choose Discover All, each prevalence of the standards you are looking for is listed, and choosing a selected prevalence within the listing selects its cell. You’ll be able to type the outcomes of a Discover All search by choosing a column heading.

3. Choose Choices>> to additional outline your search if wanted:

   • Inside: To seek for knowledge in a worksheet or in a complete workbook, choose Sheet or Workbook.

   • Search: You’ll be able to select to go looking both By Rows (default), or By Columns.

   • Look in: To seek for knowledge with particular particulars, within the field, choose Formulation, Values, Notes, or Feedback.

     Notice:   Formulation, Values, Notes and Feedback can be found solely on the Discover tab; solely Formulation can be found on the Exchange tab.

   • Match case – Verify this if you wish to seek for case-sensitive knowledge.

   • Match total cell contents – Verify this if you wish to seek for cells that include solely the characters that you just typed within the Discover what field.

4. If you wish to seek for textual content or numbers with particular formatting, choose Format, after which make your picks within the Discover Format dialog field.

   Tip: If you wish to discover cells that simply match a selected format, you possibly can delete any standards within the Discover what field, after which choose a selected cell format for example. Choose the arrow subsequent to Format, choose Select Format From Cell, after which choose the cell that has the formatting that you just need to seek for.

Exchange

To switch textual content or numbers, press Ctrl+H, or go to Dwelling > Enhancing > Discover & Choose > Exchange.

Notice: Within the following instance, we have chosen Choices >> to point out all the Discover dialog field. By default, it shows with Choices hidden.

1. Within the Discover what field, kind the textual content or numbers you need to discover, or choose the arrow within the Discover what field, after which choose a latest search merchandise from the listing.

   Suggestions: 

   • You should use wildcard characters — query mark (?), asterisk (*), tilde (~) — in your search standards.

   • Use the query mark (?) to seek out any single character — for instance, s?t finds “sat” and “set”.

   • Use the asterisk (*) to seek out any variety of characters — for instance, s*d finds “unhappy” and “began”.

   • Use the tilde (~) adopted by ?, *, or ~ to seek out query marks, asterisks, or different tilde characters — for instance, fy91~? finds “fy91?”.

2. Within the Exchange with field, enter the textual content or numbers you need to use to exchange the search textual content.

3. Choose Exchange All or Exchange.

   Tip: When you choose Exchange All, each prevalence of the standards that you just’re looking for is changed, whereas Exchange updates one prevalence at a time.

4. Choose Choices>> to additional outline your search if wanted:

   • Inside: To seek for knowledge in a worksheet or in a complete workbook, choose Sheet or Workbook.

   • Search: You’ll be able to select to go looking both By Rows (default), or By Columns.

   • Look in: To seek for knowledge with particular particulars, within the field, choose Formulation, Values, Notes, or Feedback.

     Notice:   Formulation, Values, Notes and Feedback can be found solely on the Discover tab; solely Formulation can be found on the Exchange tab.

   • Match case – Verify this if you wish to seek for case-sensitive knowledge.

   • Match total cell contents – Verify this if you wish to seek for cells that include solely the characters that you just typed within the Discover what field.

5. If you wish to seek for textual content or numbers with particular formatting, choose Format, after which make your picks within the Discover Format dialog field.

   Tip: If you wish to discover cells that simply match a selected format, you possibly can delete any standards within the Discover what field, after which choose a selected cell format for example. Choose the arrow subsequent to Format, choose Select Format From Cell, after which choose the cell that has the formatting that you just need to seek for.

There are two distinct strategies for locating or changing textual content or numbers on the Mac. The primary is to make use of the Discover & Exchange dialog field. The second is to make use of the Search bar within the ribbon.

Discover & Exchange dialog field

Discover textual content or numbers with Discover & Exchange
 

1. Press Ctrl+F or go to Dwelling > Discover & Choose > Discover.

2. In Discover what kind the textual content or numbers you need to discover.

3. Choose Discover Subsequent to run your search.

4. You’ll be able to additional outline your search:

   • Inside: To seek for knowledge in a worksheet or in a complete workbook, choose Sheet or Workbook.

   • Search: You’ll be able to select to go looking both By Rows (default), or By Columns.

   • Look in: To seek for knowledge with particular particulars, within the field, choose Formulation, Values, Notes, or Feedback.

   • Match case – Verify this if you wish to seek for case-sensitive knowledge.

   • Match total cell contents – Verify this if you wish to seek for cells that include solely the characters that you just typed within the Discover what field.

Suggestions: 

• You should use wildcard characters — query mark (?), asterisk (*), tilde (~) — in your search standards.

• Use the query mark (?) to seek out any single character — for instance, s?t finds “sat” and “set”.

• Use the asterisk (*) to seek out any variety of characters — for instance, s*d finds “unhappy” and “began”.

• Use the tilde (~) adopted by ?, *, or ~ to seek out query marks, asterisks, or different tilde characters — for instance, fy91~? finds “fy91?”.

Discover textual content or numbers with Discover All

1. Press Ctrl+F or go to Dwelling > Discover & Choose > Discover.

2. In Discover what kind the textual content or numbers you need to discover.

3. Choose Discover All to run your seek for all occurrences.

   
    

   Notice:  The dialog field expands to point out an inventory of all of the cells that include the search time period, and the entire variety of cells wherein it seems.

4. Choose any merchandise within the listing to spotlight the corresponding cell in your worksheet.
    

   Notice: You’ll be able to edit the contents of the highlighted cell.

Exchange textual content or numbers with the Discover & Exchange 

1. Press Ctrl+H or go to Dwelling > Discover & Choose > Exchange.

2. In Discover what, kind the textual content or numbers you need to discover.

3. You’ll be able to additional outline your search:

   • Inside: To seek for knowledge in a worksheet or in a complete workbook, choose Sheet or Workbook.

   • Search: You’ll be able to select to go looking both By Rows (default), or By Columns.

   • Match case – Verify this if you wish to seek for case-sensitive knowledge.

   • Match total cell contents – Verify this if you wish to seek for cells that include simply the characters that you just typed within the Discover what field.
      

     Suggestions: 

     • You should use wildcard characters — query mark (?), asterisk (*), tilde (~) — in your search standards.

     • Use the query mark (?) to seek out any single character — for instance, s?t finds “sat” and “set”.

     • Use the asterisk (*) to seek out any variety of characters — for instance, s*d finds “unhappy” and “began”.

     • Use the tilde (~) adopted by ?, *, or ~ to seek out query marks, asterisks, or different tilde characters — for instance, fy91~? finds “fy91?”.

4. Within the Exchange with field, enter the textual content or numbers you need to use to exchange the search textual content.

5. Choose Exchange or Exchange All.

   Suggestions: 

   • When you choose Exchange All, each prevalence of the standards that you’re looking for is changed.

   • When you choose Exchange, you possibly can change one occasion at a time by choosing Subsequent to spotlight the subsequent occasion.

Discover textual content or numbers from the Search bar

1. Choose any cell to go looking all the sheet or choose a selected vary of cells to go looking.

2. Press Cmd + F or choose the magnifying glass to increase the Search bar and sort the textual content or quantity you need to discover within the search area.

   Suggestions: 

   • You should use wildcard characters — query mark (?), asterisk (*), tilde (~) — in your search standards.

   • Use the query mark (?) to seek out any single character — for instance, s?t finds “sat” and “set”.

   • Use the asterisk (*) to seek out any variety of characters — for instance, s*d finds “unhappy” and “began”.

   • Use the tilde (~) adopted by ?, *, or ~ to seek out query marks, asterisks, or different tilde characters — for instance, fy91~? finds “fy91?”.

3. Press return.

   Notes: 

   • To seek out the subsequent occasion of the merchandise you might be looking for, press return once more or use the Discover dialog field and choose Discover Subsequent.

   • To specify extra search choices, choose the magnifying glass and choose Search in Sheet or Search in Workbook. You may as well choose the Superior possibility, which launches the Discover dialog field.

   Tip: You’ll be able to cancel a search in progress by urgent ESC.

Discover

To seek out one thing, press Ctrl+F, or go to Dwelling > Enhancing > Discover & Choose > Discover.

Notice: Within the following instance, we have chosen > Search Choices to point out all the Discover dialog field. By default, it shows with Search Choices hidden.

1. Within the Discover what field, kind the textual content or numbers you need to discover.

   Suggestions: 

   • You should use wildcard characters — query mark (?), asterisk (*), tilde (~) — in your search standards.

   • Use the query mark (?) to seek out any single character — for instance, s?t finds “sat” and “set”.

   • Use the asterisk (*) to seek out any variety of characters — for instance, s*d finds “unhappy” and “began”.

   • Use the tilde (~) adopted by ?, *, or ~ to seek out query marks, asterisks, or different tilde characters  — for instance, fy91~? finds “fy91?”.

2. Choose Discover Subsequent or Discover All to run your search.

   Tip: When you choose Discover All, each prevalence of the standards that you just’re looking for is listed, and choosing a selected prevalence within the listing selects its cell. You’ll be able to type the outcomes of a Discover All search by choosing a column heading.

3. Choose > Search Choices to additional outline your search if wanted:

   • Inside: To seek for knowledge inside a sure choice, select Choice. To seek for knowledge in a worksheet or in a complete workbook, choose Sheet or Workbook.

   • Route: You’ll be able to select to go looking both Down (default), or Up.

   • Match case – Verify this if you wish to seek for case-sensitive knowledge.

   • Match total cell contents – Verify this if you wish to seek for cells that include solely the characters that you just typed within the Discover what field.

Exchange

To switch textual content or numbers, press Ctrl+H, or go to Dwelling > Enhancing > Discover & Choose > Exchange.

Notice: Within the following instance, we have chosen > Search Choices to point out all the Discover dialog field. By default, it shows with Search Choices hidden.

1. Within the Discover what field, kind the textual content or numbers you need to discover.

   Suggestions: 

   • You should use wildcard characters — query mark (?), asterisk (*), tilde (~) — in your search standards.

   • Use the query mark (?) to seek out any single character — for instance, s?t finds “sat” and “set”.

   • Use the asterisk (*) to seek out any variety of characters — for instance, s*d finds “unhappy” and “began”.

   • Use the tilde (~) adopted by ?, *, or ~ to seek out query marks, asterisks, or different tilde characters  — for instance, fy91~? finds “fy91?”.

2. Within the Exchange with field, enter the textual content or numbers you need to use to exchange the search textual content.

3. Choose Exchange or Exchange All.

   Tip: When you choose Exchange All, each prevalence of the standards that you just’re looking for is changed, whereas Exchange updates one prevalence at a time.

4. Choose > Search Choices to additional outline your search if wanted:

   • Inside: To seek for knowledge inside a sure choice, select Choice. To seek for knowledge in a worksheet or in a complete workbook, choose Sheet or Workbook.

   • Route: You’ll be able to select to go looking both Down (default), or Up.

   • Match case – Verify this if you wish to seek for case-sensitive knowledge.

   • Match total cell contents – Verify this if you wish to seek for cells that include solely the characters you typed within the Discover what field.