![]() ![]() To search for the specified value in the current worksheet or entire workbook, select Sheet or Workbook in the Within.To fine-tune your search, click Options in the right-hand corner of the Excel Find & Replace dialog, and then do any of the following: When you click Find All, Excel opens a list of all the occurrences, and you can click any item in the list to navigate to the corresponding cell. When you click Find Next, Excel selects the first occurrence of the search value on the sheet, the second click selects the second occurrence, and so on. In the Find what box, type the characters (text or number) you are looking for and click either Find All or Find Next.Alternatively, go to the Home tab > Editing group and click Find & Select > Find… ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |