Match entire cell contents tells Excel to only return cells that match your search query exactly, and don’t contain anything else.Match case makes the search case-sensitive.Look in: tells Excel where to look for your search query (we’ll talk about this in a moment).Search: sets the search to run by row or by column, changing the order in which you’ll see your search results-this can be useful if you have a massive spreadsheet and want to the search to run left-to-right instead of up-to-down.Within: allows you to choose to search the entire workbook, instead of a single sheet. Format… lets you narrow your search to specific cell formats (we’ll see shortly how useful this can be).You’ll see a wide variety of new choices. Now that you have basic searching down, let’s take a look at some of the more advanced options you have for finding data.Ĭlick the Options > button in the Find and Replace dialog.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |