How to use drag autofill correctly?

[schoolquestion140]

For instance, when I drag a numbered cell (1, 2, 3, etc), how do I make it so that instead of continuing the numbers (4, 5, 6, etc), I can have it copy the same thing respectively. (123, 123, 123). Thanks.

 

[My Aswer Is This]

Put 123 in like A1 and
Put 123 in like A2 and select A1 and A2
And drag down

 

[Peter_SSs]

Welcome to the MrExcel board!

Select the 3 cells then hold the Ctrl key and drag the Fill Handle down.

 

[My Aswer Is This]

On my computer using Excel 2013
I do not need to hold down the Ctrl Key

 

[Peter_SSs]

On my computer using Excel 2013
I do not need to hold down the Ctrl Key

I believe that you have interpreted the question differently to me.

 

[My Aswer Is This]

I believe that you have interpreted the question differently to me.

I understood the request to be if I want to keep repeating 123
So, I said:
Put 123 in A1
Put 123 in A2

Then select Range A1 To A2
And drag down to repeat 123

 

[Peter_SSs]

Yes, I understood how you interpreted it and what you wrote.