Hi, thanks for your reply.

You've confirmed what I suspected, I just wondered if there was a way around
it.

Thanks any way.

Louise

"Peo Sjoblom" wrote:

As far as I know there is no way of bypassing that, it's because Excel can
copy non contiguous cells and paste them in one solid block but it cannot do
it the other way around. So even if you use something that will fill like a
series it will
skip the filtered rows

=ROWS($A$1:A1)

copied down will return 1,2,3 and so on but if the first values in your
filtered list is in row 2 and second value is in row 5 it will fill like 1,
4 and so on



--
Regards,

Peo Sjoblom


"Louise" wrote in message
...
Hi all

I have a large worksheet and have set an AutoFilter on the data, to
display
the information I need, however, I now need to insert a new column (A) and
number the entries on the filtered list as 1, 2, 3 etc.

When I enter 1 and 2, highlight them both and drag down, it doesn't fill
in
with 3, 4 etc. it gives me a list of 1's. I am presuming this is because
it
recognises the list is filtered.

Is there any way I can auto-number this filtered list?

THank you.
Louise