Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
cljenkins
 
Posts: n/a
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
pinmaster
 
Posts: n/a
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.misc
Frank C
 
Posts: n/a
Default 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?

  #4   Report Post  
Posted to microsoft.public.excel.misc
cljenkins
 
Posts: n/a
Default 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


  #5   Report Post  
Posted to microsoft.public.excel.misc
cljenkins
 
Posts: n/a
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pasword protected Excel file encrypted, how do I read this file? jonesteam Excel Discussion (Misc queries) 2 December 12th 05 06:32 PM
Reflecting info between an excel file and a word one or two excel file. Starriol Excel Worksheet Functions 0 November 3rd 05 01:49 PM
Reflecting info between an excel file and a word one or two excel file. Starriol Links and Linking in Excel 0 November 3rd 05 01:49 PM
Reflecting info between an excel file and a word one or two excel file. Starriol Excel Discussion (Misc queries) 0 November 3rd 05 01:49 PM
Exporting excel to text file Exceluser Excel Discussion (Misc queries) 1 July 1st 05 03:04 AM


All times are GMT +1. The time now is 02:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"