search box in excel 2003?
 

I use excel 2003

Is there a way to create a search box on the top of a sheet instead of
continually using the find option under "edit".

I would like to be able to find a particular employee amongst 5600 rows then
change data, but the find option is pretty time intense when finding a
person in a row.

or is there a better way to do this in excel 2003?
TIA,
_Bigred

search box in excel 2003?
 

I don't think you'll find anything easier than the edit|find option, but you
could try selecting your column and doing Data|filter|Autofilter.

You'll be able to filter to show the name you want.

_Bigred wrote:

I use excel 2003

Is there a way to create a search box on the top of a sheet instead of
continually using the find option under "edit".

I would like to be able to find a particular employee amongst 5600 rows then
change data, but the find option is pretty time intense when finding a
person in a row.

or is there a better way to do this in excel 2003?
TIA,
_Bigred

--

Dave Peterson