Autofilter, not autocorrect.

You can click the dropdown arrow.
Choose Custom
and equals 1010
(you can type it in)

Satya wrote:

In an Excel Sheet , when we apply auto correct to the colum having numbers 1
to 1010 we can locate only up to 1000 , but if we want to locate 1005 what we
will do?

"SteveG" wrote:


Satya,

Autofilter will only show you the first 1000 unique records in your
list. To find the job # over 1000, click on the arrow, select Custom
and your criteria would be equals and the job number over 1000 you are
looking for. That will display only that item in the list.

Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=490691



--

Dave Peterson