Chức năng find and replace trong excel

     
Excel for thietkewebshop.vn 365 Excel for thietkewebshop.vn 365 for Mac Excel for the web Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Excel năm 2016 Excel năm 2016 for Mac Excel 2013 Excel 2010 Excel 2007 Excel for Mac 2011 Excel Starter 2010 More...Less

Use the Find and Replace features in Excel to tìm kiếm for something in your workbook, such as a particular number or text string. You can either locate the search item for reference, or you can replace it with something else. You can include wildcard characters such as question marks, tildes, và asterisks, or numbers in your tìm kiếm terms. You can search by rows & columns, tìm kiếm within comments or values, and search within worksheets or entire workbooks.

Bạn đang xem: Chức năng find and replace trong excel


*

Note: In the following example, we"ve clicked the Options >> button to show the entire Find dialog. By default, it will display with Options hidden.


*

In the Find what: box, type the text or numbers you want to find, or click the arrow in the Find what: box, & then select a recent tìm kiếm item from the list.


Tips: You can use wildcard characters — question mark (?), asterisk (*), tilde (~) — in your tìm kiếm criteria.

Use the question mark (?) to lớn find any single character — for example, s?t finds "sat" và "set".

Use the asterisk (*) to find any number of characters — for example, s*d finds "sad" và "started".

Use the tilde (~) followed by ?, *, or ~ to find question marks, asterisks, or other tilde characters — for example, fy91~? finds "fy91?".


Tip: When you click Find All, every occurrence of the criteria that you are searching for will be listed, & clicking a specific occurrence in the danh mục will select its cell. You can sort the results of a Find All search by clicking a column heading.


Click Options>> lớn further define your search if needed:

Within: To search for data in a worksheet or in an entire workbook, select Sheet or Workbook.

Search: You can choose to search either By Rows (default), or By Columns.

Look in: To search for data with specific details, in the box, click Formulas, Values, Notes, or Comments.


Note:   Formulas, Values, Notes and Comments are only available on the Find tab; only Formulas are available on the Replace tab.


Match case - kiểm tra this if you want to tìm kiếm for case-sensitive data.

Match entire cell contents - kiểm tra this if you want to search for cells that contain just the characters that you typed in the Find what: box.

If you want to tìm kiếm for text or numbers with specific formatting, click Format, and then make your selections in the Find Format dialog box.


Tip: If you want to lớn find cells that just match a specific format, you can delete any criteria in the Find what box, và then select a specific cell format as an example. Click the arrow next lớn Format, click Choose Format From Cell, & then click the cell that has the formatting that you want to search for.


Replace

To replace text or numbers, press Ctrl+H, or go lớn Home > Editing > Find và Select > Replace.


Note: In the following example, we"ve clicked the Options >> button to show the entire Find dialog. By default, it will display with Options hidden.


*

In the Find what: box, type the text or numbers you want lớn find, or click the arrow in the Find what: box, and then select a recent tìm kiếm item from the list.


Tips: You can use wildcard characters — question mark (?), asterisk (*), tilde (~) — in your search criteria.

Use the question mark (?) lớn find any single character — for example, s?t finds "sat" and "set".

Use the asterisk (*) lớn find any number of characters — for example, s*d finds "sad" và "started".

Use the tilde (~) followed by ?, *, or ~ lớn find question marks, asterisks, or other tilde characters — for example, fy91~? finds "fy91?".


In the Replace with: box, enter the text or numbers you want khổng lồ use lớn replace the search text.

Click Replace All or Replace.


Tip: When you click Replace All, every occurrence of the criteria that you are searching for will be replaced, while Replace will update one occurrence at a time.


Click Options>> lớn further define your tìm kiếm if needed:

Within: To search for data in a worksheet or in an entire workbook, select Sheet or Workbook.

Search: You can choose to search either By Rows (default), or By Columns.

Look in: To tìm kiếm for data with specific details, in the box, click Formulas, Values, Notes, or Comments.


Note:   Formulas, Values, Notes and Comments are only available on the Find tab; only Formulas are available on the Replace tab.


Match case - check this if you want to search for case-sensitive data.

Match entire cell contents - check this if you want to search for cells that contain just the characters that you typed in the Find what: box.

If you want to search for text or numbers with specific formatting, click Format, and then make your selections in the Find Format dialog box.


Tip: If you want to lớn find cells that just match a specific format, you can delete any criteria in the Find what box, và then select a specific cell format as an example. Click the arrow next to Format, click Choose Format From Cell, and then click the cell that has the formatting that you want to search for.


There are two distinct methods for finding or replacing text or numbers on the Mac. The first is to lớn use the Find và Replace dialog. The second is khổng lồ use the Search bar in the ribbon.



*


To find something, press Ctrl+F, or go khổng lồ Home > Find và Select > Find.

*

In the Find what: box, type the text or numbers you want to lớn find.

Click Find Next khổng lồ run your search.

You can further define your tìm kiếm if needed:

Within: To tìm kiếm for data in a worksheet or in an entire workbook, select Sheet or Workbook.

Search: You can choose to tìm kiếm either By Rows (default), or By Columns.

Look in: To search for data with specific details, in the box, click Formulas, Values, Notes, or Comments.


Note:   Formulas, Values, NotesComments are only available on the Find tab; only Formulas are available on the Replace tab.


Match case - kiểm tra this if you want to search for case-sensitive data.

Match entire cell contents - check this if you want to search for cells that contain just the characters that you typed in the Find what: box.


Tips: You can use wildcard characters — question mark (?), asterisk (*), tilde (~) — in your tìm kiếm criteria.

Use the question mark (?) lớn find any single character — for example, s?t finds "sat" và "set".

Use the asterisk (*) to lớn find any number of characters — for example, s*d finds "sad" and "started".

Use the tilde (~) followed by ?, *, or ~ lớn find question marks, asterisks, or other tilde characters — for example, fy91~? finds "fy91?".


Replace text or numbers with the Find & Replace dialog

To replace text or numbers, press Ctrl+H, or go khổng lồ Home > Find & Select > Replace.

In the Find what box, type the text or numbers you want lớn find.

In the Replace with box, enter the text or numbers you want lớn use to replace the tìm kiếm text.

Click Replace or Replace All.


Tip: When you click Replace All, every occurrence of the criteria that you are searching for will be replaced, while Replace will update one occurrence at a time.


You can further define your search if needed:

Within: To tìm kiếm for data in a worksheet or in an entire workbook, select Sheet or Workbook.

Search: You can choose to search either By Rows (default), or By Columns.

Match case - kiểm tra this if you want to search for case-sensitive data.

Match entire cell contents - kiểm tra this if you want to search for cells that contain just the characters that you typed in the Find what: box.

Xem thêm: Túi Ối Méo Đã Có Tim Thai - Có Tim Thai Nhưng Túi Ối Méo


Tips: You can use wildcard characters — question mark (?), asterisk (*), tilde (~) — in your tìm kiếm criteria.

Use the question mark (?) khổng lồ find any single character — for example, s?t finds "sat" & "set".

Use the asterisk (*) to find any number of characters — for example, s*d finds "sad" and "started".

Use the tilde (~) followed by ?, *, or ~ lớn find question marks, asterisks, or other tilde characters — for example, fy91~? finds "fy91?".


Find text or numbers from the search bar

Click any cell to tìm kiếm the entire sheet, or select a specific range of cells khổng lồ search.

Press +F or click the icon to lớn expand the tìm kiếm bar, then In the tìm kiếm field , type the text or number that you want lớn find.


Tips: You can use wildcard characters — question mark (?), asterisk (*), tilde (~) — in your search criteria.

Use the question mark (?) to find any single character — for example, s?t finds "sat" và "set".

Use the asterisk (*) to lớn find any number of characters — for example, s*d finds "sad" và "started".

Use the tilde (~) followed by ?, *, or ~ khổng lồ find question marks, asterisks, or other tilde characters — for example, fy91~? finds "fy91?".


Press the Return key.

To find the next instance of the sản phẩm that you"re searching for, click in the tìm kiếm field và press Return, or in the Find dialog box, click Find Next.


Tip: You can cancel a tìm kiếm in progress by pressing ESC .


To specify additional tìm kiếm options, click the magnifying glass, and then click Search in Sheet or Search in Workbook. You can also select the Advanced option, which will launch the Find dialog.


Replace text or numbers from the search pane

Click any cell to tìm kiếm the entire sheet, or select a specific range of cells khổng lồ search.

Press +F to expand the tìm kiếm bar, then In the tìm kiếm field , type the text or number that you want to lớn find.


Tips: You can use wildcard characters — question mark (?), asterisk (*), tilde (~) — in your tìm kiếm criteria.

Use the question mark (?) khổng lồ find any single character — for example, s?t finds "sat" and "set".

Use the asterisk (*) to lớn find any number of characters — for example, s*d finds "sad" and "started".

Use the tilde (~) followed by ?, *, or ~ lớn find question marks, asterisks, or other tilde characters — for example, fy91~? finds "fy91?".


In the tìm kiếm field, click the magnifying glass, và then click Replace.

In the Replace with box, type the replacement characters.

To replace the characters in the Find what field with nothing, leave the Replace with field empty.

Click Find Next.

To replace the highlighted occurrence, click Replace.

To replace all occurrences of the characters in the sheet without reviewing them first, click Replace All.


Tip: Cancel a tìm kiếm that is in progress simply by pressing ESC.


To specify additional tìm kiếm options, click the magnifying glass, & then click Search in Sheet or Search in Workbook. You can also select the Advanced option, which will launch the Replace dialog.


Find

To find something, press Ctrl+F, or go to Home > Editing > Find & Select > Find.


Note: In the following example, we"ve clicked > tìm kiếm Options to lớn show the entire Find dialog. By default, it will display with search Options hidden.


*

In the Find what: box, type the text or numbers you want khổng lồ find.


Tips: You can use wildcard characters — question mark (?), asterisk (*), tilde (~) — in your search criteria.

Use the question mark (?) to find any single character — for example, s?t finds "sat" and "set".

Use the asterisk (*) to lớn find any number of characters — for example, s*d finds "sad" and "started".

Use the tilde (~) followed by ?, *, or ~ khổng lồ find question marks, asterisks, or other tilde characters — for example, fy91~? finds "fy91?".


Click Find Next or Find All to run your search.


Tip: When you click Find All, every occurrence of the criteria that you are searching for will be listed, & clicking a specific occurrence in the menu will select its cell. You can sort the results of a Find All tìm kiếm by clicking a column heading.


Click > search Options khổng lồ further define your tìm kiếm if needed:

Within: To tìm kiếm for data within a certain selection, choose Selection. To search for data in a worksheet or in an entire workbook, select Sheet or Workbook.

Direction: You can choose to tìm kiếm either Down (default), or Up.

Match case - check this if you want to search for case-sensitive data.

Match entire cell contents - check this if you want to tìm kiếm for cells that contain just the characters that you typed in the Find what box.

Replace

To replace text or numbers, press Ctrl+H, or go khổng lồ Home > Editing > Find & Select > Replace.


Note: In the following example, we"ve clicked > search Options lớn show the entire Find dialog. By default, it will display with tìm kiếm Options hidden.


*

In the Find what: box, type the text or numbers you want khổng lồ find.


Tips: You can use wildcard characters — question mark (?), asterisk (*), tilde (~) — in your tìm kiếm criteria.

Use the question mark (?) to lớn find any single character — for example, s?t finds "sat" and "set".

Use the asterisk (*) khổng lồ find any number of characters — for example, s*d finds "sad" and "started".

Use the tilde (~) followed by ?, *, or ~ to lớn find question marks, asterisks, or other tilde characters — for example, fy91~? finds "fy91?".


In the Replace with: box, enter the text or numbers you want lớn use to replace the tìm kiếm text.

Click Replace or Replace All.


Tip: When you click Replace All, every occurrence of the criteria that you are searching for will be replaced, while Replace will update one occurrence at a time.


Click > tìm kiếm Options to lớn further define your tìm kiếm if needed:

Within: To search for data within a certain selection, choose Selection. To search for data in a worksheet or in an entire workbook, select Sheet or Workbook.

Direction: You can choose to search either Down (default), or Up.

Match case - kiểm tra this if you want to search for case-sensitive data.

Match entire cell contents - kiểm tra this if you want to tìm kiếm for cells that contain just the characters that you typed in the Find what box.

Xem thêm: Cách Mở Phản Chiếu Màn Hình Trên Iphone Lên Tivi Không Cần Dây Cáp Đơn Giản


Need more help?

You can always ask an expert in the Excel Tech Community or get thietkewebshop.vn in the Answers community.


*
*
*

Need more help?


Expand your skills
Explore Training
Get new features first
Join thietkewebshop.vn Office Insiders

Was this information helpful?


YesNo
Thank you! Any more feedback? (The more you tell us the more we can help.)Can you help us improve? (The more you tell us the more we can help.)
What affected your experience?
Resolved my issue
Clear instructions
Easy to lớn follow
No jargon
Pictures helped
Other
Didn"t match my screen
Incorrect instructions
Too technical
Not enough information
Not enough pictures
Other
Any additional feedback? (Optional)
Submit feedback

Thank you for your feedback!


×
What's new
thietkewebshop.vn Store
Education
Business
Developer & IT
Company
English (United States) © thietkewebshop.vn 2022