hi.. apologies if this has been covered somewhere else before, but having done various searches for any existing threads, i couldn't find anything quickly that didn't involve trawling through over 163 pages.

i have a spreadsheet which when filtered, i want to use the 'autofill/sequential numbering' option in a column. It works when it's not filtered (ie I insert 1/2 and then double click the square which will then autofill the remaining rows in the column), but doesn't work with a filtered range. Is there a way to do this?

ie:
1
2
3
4
5
6
etc....

if someone has seen this topic covered before and has the link, please do provide that and feel free to close this one off.

thank you
Kaycee