Occasionally, you"ll have a word or number you need to find somewhere in your spreadsheet, but you"re not sure where it is. Excel’s Find and Replace commands scan a worksheet for labels & values with just a few clicks of the mouse.

Bạn đang xem: Find & replace question marks and asterisks in excel & google sheets

Find Text

The Find feature makes it very easy to find specific words & values in a worksheet.

Click the Find & Select button on the trang chủ tab.Select Find.

Press Ctrl + F.

The Find tab of the Find & Replace dialog box appears.

Type the text you want to find in the Find what box.Click Find Next.

Excel jumps to lớn the first occurrence of the word, phrase, or value that you entered.

Click the Find Next button again to move on to other occurrences.

Click Find All to find the cell location of all instances at once.

Click Close when you"re finished.

Replace Text

Now, if you have a word that appears throughout a spreadsheet & needs to lớn be updated, don"t update it cell by cell, use Replace instead.

Click the Find và Select button on the trang chủ tab.Select Replace.

Press Ctrl + H.

The Replace tab of the Find và Replace dialog box appears.

Type the text you want khổng lồ replace in the Find what box.Type the replacement text in the Replace with box.Click the Find Next button.

The first instance is selected.

Xem thêm: Tổng Hợp 5 Game Nấu Ăn Nhà Hàng Vui Vẻ, Hành Trình Nấu Ăn Đầu Bếp Điên

Click any of the following:Replace All: Replace every occurrence of the item.Replace: Replace the selected item.Find All: Find all instances of the item.Find Next: Find the next instance of the item.Click Close when you"re finished.

Advanced Find and Replace

You can use Excel’s tìm kiếm options to change how Excel searches the workbook.

Click the Find & Select button.Select Find or Replace.Click the Options button.

Additional options appear, as described in following table.

Complete the search / replace as you normally would.Select the desired advanced Find & Replace options.
Find OptionDescription
WithinChoose whether to search within just the current sheet or the entire workbook.
SearchSearch by rows (left khổng lồ right, then vị trí cao nhất to bottom) or columns (top khổng lồ bottom, then left lớn right).
Look inSpecify which kinds of data to tìm kiếm in, such as formulas, values, or comments.
Match caseSearches exactly as text is typed in the text box.
Match entire cell contentsSearches only for cells that match the contents in the text box entirely. Parts of phrases or words are not included.
FormatSearches for và replaces text, including character and paragraph formats, special characters, document elements, styles, & highlighting.

FREE Quick Reference

Click lớn Download

Free lớn distribute with our compliments; we hope you will consider our paid training.


quartetpress.com helps over 3,000 organizations measure và improve their users" skills for success in today"s workplace. Learn With: - Interactive Tutorials - Skills Assessments - Customizable Courseware - Quick References