Excel find fuction

Microsoft Microsoft excel 2000
April 20, 2010 at 14:17:46
Specs: Windows Vista
Having an issue, I had a search function in Excel and now it is gone. The function would search my workbook and find by name, but now I lost the option function on the search box. How can I restore it? I know I can click on the tab and select all but that takes to long. The function also showed a drop down box with other names that were the same.

See More: Excel find fuction

Report •


#1
April 20, 2010 at 14:41:38
Are you asking about the built-in Edit...Find and Replace feature or a custom search feature that was added?

re: The function also showed a drop down box with other names that were the same

Other names that were the same?

The same as what?


Report •

#2
April 20, 2010 at 14:59:51
It wasn't added it was part of the search. Finding names in a workbook, if I put in McKamy and there were other individuals it would appear in a drop down box in the search function.

Report •

#3
April 20, 2010 at 16:45:43
Obviously, without seeing your situation it's hard for me to understand exactly what is missing.

I just want to make sure we are talking about the same thing.

In my Excel 2003 installation, it's not called "Search", it's called Find and Replace.

If there is more than one instance of the value I am trying to find, they don't appear in a "drop down" (which is usually indicated by an downward pointing triangle)...they appear in a small window with a vertical scroll bar.

The "Option" button expands the Find and Replace dialog box and allows me to look within the sheet or the workbook, Match Case, Look in: Formulas, Values, or Comments, etc.

See here:

http://img693.imageshack.us/img693/...

Is this the feature that you are having problems with? If so, what are you seeing (or not seeing)?


Report •

Related Solutions

#4
April 20, 2010 at 17:49:02
Yes, this function is gone, I have Excel 2000 it work with it before but it has disappeared for some reason. How can i get it back?

Report •

#5
April 20, 2010 at 19:08:00
What happens if you press Ctrl-F?

That is the key sequence to bring up the Find and Replace dialog box.

If it has really disappeared from the Edit menu, try this:

1 - Tools...Customize...Commands tab
2 - Under Categories, select Edit
3 - On the Commands side, scroll down to Find...
4 - Click on Find..., hold the mouse button down and Drag it over the word Edit on the toolbar.
5 - When the Edit menu opens, drag the Find button to wherever you want it and release the mouse.
6 - If Replace is also missing, drag that button up also.


Report •

#6
April 21, 2010 at 08:55:37
This is what I need:
http://img693.imageshack.us/img693/...

How can i get it for Excel 2000?


Report •

#7
April 21, 2010 at 09:02:16
I can't access imageshack from my work computer, so I can't see your image.

Earlier you said that the image I posted was what you were looking for. Is that not the feature you are having problems with?

What happens if you hit Ctrl-F?


Report •

#8
April 21, 2010 at 09:42:53
When i do that I get the Find box: But I had the one you dsent and now it is gone?

Report •

#9
April 21, 2010 at 10:14:58
Did you read my Response # 5?

I gave you the steps on how to add the Find and Replace functions to your Edit menu by going through the Tools...Customize process.

Did you try those steps?


Report •

#10
April 21, 2010 at 10:19:46
Hi,

The image shown by DerbyDad03 (and repeated in your response number 6) is the Find and Replace dialog that is part of Excel 2003.

The version that was part of Excel 2000 is slightly different. It does not have drop-downs in the find and replace boxes.

So you will not be able to get the 2003 version in Excel 2000.

Do you have any Find or Replace menu items or dialog boxes available.

Regards


Report •

#11
April 21, 2010 at 12:03:00
Do you have any Find or Replace menu items or dialog boxes available.

The only thing in the Find and Replace is:
Just search: Rows or by Columns
Match case or Find entire cell only.

There is nothing else!


Report •


Ask Question