How to repeat the same number multiple times in excel

Multiple methods: Fill Handle, Ctrl + Enter, =cell reference, SEQUENCE & RANDARRAY
---------------------------------------------------------------------------------
#exceltips #exceltutorials #excelformulas

Microsoft Office 365, Beta Channel, Version 2106
---------------------------------------------------------------------------------
IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE:

[misterwill]

This is exactly what I needed. Thank you. You tagged it well because I found it immediately.

[cheeseburgerwalrus]

I love this video. I've never been a fan of Excel, or spreadsheets in general, but I've dealt with Excel docs for years now at my current job. Now I am in the position of writing my own "scripts" (which are always expected to be delivered as, xls files). The simple ability to duplicate one cell to the other saves me 20 minutes of effort for each one I am writing, and that's no joke. Instead of simple copy and paste hotkeys, I now know how to drag to replicate that cell.

Remedial for many. Life changing for others (such as myself). I will still continue to hate Excel, but at least I can hate it a little less now.

[dimetraveler]

Suppose I want to copy same things between A2 to C12 and copy it 69 times below one after the other.how to do it?

[dwinissaananda]

Thank you so much this tutorial was awesome!

[mohamedjanahi]

how to use the black cross which will give me multiple copies of the cell by the keyborad instead of the mouse?

[tinasheyadley]

Maa`m, you just saved me a ton of work. Thank you so much!

[lurksparr]

How about in Google Sheets? Please help

[patrickschardt]

Great work as always. This could easily be converted to a LAMBDA function with arguments of value to repeat (easy to implement repeating text), number of rows, and number of columns

[mylazyroots]

I tried this. It kept adding 1 each cell. So 6, 7, 8 etc.

[Azolutions]

Thanks a lot. The video was really informative and helped me save time.

[florincopaci]

Thank you for this video! I have a huge request-it is possible to do in the future a video where to explain with few examples the MMULT function in Excel ? Please.Thank you in advance

[EmeraldQueue]

How do you create auto fill in a column e.g. 1, 2, 1, 2, 1, 2....

[casey]

How would I link 2 cells together? For example, if I want A1 to = B1, I can enter = on A1 and click on B2....simple.... so if I enter 5 in A1, B1 is also I am looking to link cells so no matter which one I enter 5 in (A1 or B1) they still both show 5. Using this for estimates.... Any advice would help.

[zeshankhan]

Plz explain this sir
how to repeated rows X number of time in excel vba username

[mehmetdogu]

|This sequence command better than excel edit>series section producing same numbers in 1000 rows in one 😝column.