ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do i search for a specific name in an excel file (https://www.excelbanter.com/excel-discussion-misc-queries/62169-how-do-i-search-specific-name-excel-file.html)

cljenkins

how do i search for a specific name in an excel file
 
i have a large file, (49,000+ names) is it possible to search for a specific
name somehow without scrolling up and down the list repeatedly looking for it?

pinmaster

how do i search for a specific name in an excel file
 

Hit CTRL+F to open the find window, and in Look in: select Values.

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=496546


Frank C

how do i search for a specific name in an excel file
 
Did you try Edit Find ?

"cljenkins" wrote:

i have a large file, (49,000+ names) is it possible to search for a specific
name somehow without scrolling up and down the list repeatedly looking for it?


cljenkins

how do i search for a specific name in an excel file
 
I've tried both suggestions that were posted, but it didn't help. any other
ideas?

"pinmaster" wrote:


Hit CTRL+F to open the find window, and in Look in: select Values.

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=496546



cljenkins

how do i search for a specific name in an excel file
 
Hi, Sorry~I wasn't understanding how to do the search at first, both postings
helped me, I got it!! Thanks so much!
-cljenkins

"cljenkins" wrote:

i have a large file, (49,000+ names) is it possible to search for a specific
name somehow without scrolling up and down the list repeatedly looking for it?



All times are GMT +1. The time now is 03:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com