Auto Fill Down Number List

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

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

Best
In A1 use the formula [COLOR="#0000CD"]=Row() [/COLOR]and fill down to cell A10

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

apologies yes =Row(A1) fill down

Re: Auto Fill Down Number List

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