Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I have 59,000 people with all of their info on my sheet.
can i do a one word search to find a certain name or address, etc and how? |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
brandi
On the top toolbar, click 'Edit' Find Type your word in 'Find what'. Click 'Find next'. George Gee brandi wrote: I have 59,000 people with all of their info on my sheet. can i do a one word search to find a certain name or address, etc and how? |
#3
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
59000 is quite a lot, ever thought of migrating the list to Access, then you
can query from excel A large list like that in excel using formulas will probably slow down the workbook quite a bit? -- Regards, Peo Sjoblom (No private emails please) "brandi" wrote in message ... I have 59,000 people with all of their info on my sheet. can i do a one word search to find a certain name or address, etc and how? |
#4
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Ctrl - F
Then type the word you want to find! -- @---}-- Laura..... :) Liverpool, England "Do you know where you're going to?" "brandi" wrote in message ... : I have 59,000 people with all of their info on my sheet. : can i do a one word search to find a certain name or address, etc and how? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Linking table in Excel to word | Links and Linking in Excel | |||
need formula to search column for a word and return another word | Excel Discussion (Misc queries) | |||
how can I search a field for a particular word | Excel Worksheet Functions | |||
How to Search for word in the Entire Workbook | Excel Discussion (Misc queries) | |||
Search for more than one word | Excel Worksheet Functions |