Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
1 word search
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
|
|||
|
|||
1 word search
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
|
|||
|
|||
1 word search
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
|
|||
|
|||
1 word search
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 | |
|
|
Similar Threads | ||||
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 |