Ask Mac Questions and Get Answers from Experts ASAP
How do you search a list of names at once and highlight the matches in Excel for Mac 2008
Hi, so you are searching for the same name multiple times in Excel and want to search where they are? If this is the case go to Edit-Find and type in the word you are looking for and excel will display it and click "find next" to take you to the next entry. If by highlight you mean make bold or something like that you will have to do a "find" first and then close find so you can "highlight" it.
Yes the find function lets me search 1 name at a time, I would like to search 2000 names at a time.
OK, I'm going to opt-out to let another expert try and help you with this.