Hi,

You are not very clear as to what you require exactly. Please be a little
exact in your question.

Cheers

"Satya" wrote:

In a Excel Sheet of more than 1000 recodrs when we apply Auto filter I am
facing below problem.

My record entered in a sheet are 1700 , the frst Colum is Job No. where the
job numbers starts with 1 and serially incraesed up to 1700, I have apply
auto filter.

Now to search a specific Job No, I click the arrow highliting at the Job No
heading , the Job numbers displayed are only up to 1000 , I can not go
directly to lets say 1010 Job no. For this requirement I am using Find ( Ctrl
F ) option and reaching to thr required Job number. If any one has any
solution on this plz advice