paste special numbers in sequence

[psrs0810]

If I have numbers 1-20 listed out. then delete number/row 10. so now I have 1-9 then 11-20 - no space.
How do I copy and paste so that my numbers will now be 1-19?

 

[Warship]

Select the cell with 9 in it.
On the little black square bottom right of that cell, right-click and drag down to cell with 20. Release mouse and select fill series.

 

[psrs0810]

isnt there a way to copy say 1-6 and paste special the series? - like the fill down in the bottom right

 

[Warship]

Not that I'm aware of, however you might use VBA to do it.
Why do you need this type of functionality?

 

[psrs0810]

what about hide blank row, then fill down?

This is the way the report is structured and it's not mine to manipulate. I am trying to keep the numbers in order

 

[Jonmo1]

Perhaps instead of typing the numbers in the cell, use a formula

in A1
=ROW()
Fill down to A20

Now it will update when you delete a row.

 

[psrs0810]

I did think of that, but there is spacing between the groups of numbers. That is why I was hoping to copy say 1-6, have excel recgonize the sequence, then select the cells needs and keep the sequence progressing