# Auto Fill Down Number List

• Please, help me to get list from range A1 = 1. ........... to range A10 = 10. ................, the result like list number 1 to 10.

• Re: Auto Fill Down Number List

Hi luarbiasa,
welcome to the forum
There are a many different ways to populate the cells A1 to A10 with the numbers 1 to 10
with worksheet functions
in A1 the formula [COLOR="#0000CD"]=Row() [/COLOR]and fill down to cell A10
or
in A1 type [COLOR="#0000CD"]1[/COLOR]
and in A2 [COLOR="#0000FF"][/COLOR][COLOR="#0000CD"]= A1 +1[/COLOR] and fill down to A10

• Re: Auto Fill Down Number List

How to fill down my cell contains A1 =1&". …………" or 1. …………?
if just contains 1 it's ok.

• Re: Auto Fill Down Number List

Hi
With the second method just [COLOR="#0000CD"]1[/COLOR]
or another way
in A1 type[COLOR="#0000CD"][/COLOR][COLOR="#0000CD"] 1[/COLOR] and A2 type [COLOR="#0000CD"]2[/COLOR]
select both cells and drag down to A10 and Intelsense with auto increment the numbers to ten

• Re: Auto Fill Down Number List

Please, help me. My cell contain number and text.
[TABLE="width: 64"]

[tr]

[TD="width: 64"]1.…………[/TD]

[/tr]

[tr]

[td]

2.…………

[/td]

[/tr]

[tr]

[td]

1.…………

[/td]

[/tr]

[tr]

[td]

2.…………

[/td]

[/tr]

[tr]

[td]

1.…………

[/td]

[/tr]

[tr]

[td]

2.…………

[/td]

[/tr]

[tr]

[td]

1.…………

[/td]

[/tr]

[tr]

[td]

2.…………

[/td]

[/tr]

[tr]

[td]

1.…………

[/td]

[/tr]

[tr]

[td]

2.…………

[/td]

[/tr]

[/TABLE]

• Re: Auto Fill Down Number List

thanks so much

• Re: Auto Fill Down Number List

Use the Concatenate function to add the text to the number. Try reading Help on how to use it - and think about how you are going to use this. You are not going to be able to add text later and keep the numbering.

• Re: Auto Fill Down Number List

ok, thanks so much. it works.
=ROW(A1)&"......"

• Re: Auto Fill Down Number List

thanks so much pike and Grimes0332

• Re: Auto Fill Down Number List

Select Range from A1:A10, then put formula =row() in cell A1 then press Ctrl+Enter.

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!