How To Fill Numbers In Excel Quickly And Easily!

Подписаться 588 тыс.

Просмотров 745 тыс.

50% 1

Looking for a faster way to fill in numbers and dates in Excel?
Check out this video on "Auto Fill Numbers in Excel: Must Know AUTO FILL Shortcuts". In this tutorial, you'll discover powerful shortcuts for using Excel's auto fill feature to quickly fill in sequences of numbers and dates, saving you time and streamlining your workflow.
Whether you're a beginner or an experienced Excel user, this video has something for everyone who wants to boost their productivity and optimize their spreadsheet workflow. So why waste time filling in numbers manually? Click play now and start mastering Excel's auto fill feature today!
Are you always learning something new when it comes to Excel? We definitely are.
This is why we created a playlist dedicated entirely to our Excel new tips and tricks: • Tips & Shortcuts
They'll help you master Excel so you nail that next interview, or at least find formulas, macros, VBA, and pivot tables a little less confusing...

Опубликовано:

1 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 121

@chadbullard979 7 месяцев назад

Thank you, wished I had seen this 17 years ago. Wasted a few minutes setting up numbering math formula, this way in video is so much easier and faster.

@crisp1066 3 месяца назад

Trying to put sequencial numbers in a colum. Tried your method 5 times but only get a "Quick Analysis" icon at the bottom right cell. 😡

@leavesofthetreehealing3211 10 месяцев назад

I was trying to "fill series" for sequential numbers but didn't see that option. It told me I had to grab a few cells of the series to get an idea of what I wanted it to fill the rest of them with. I was able to do that and figure it out thanks to this video. The video was extremely helpful and saved me time. Thanks again.

@datadreamsit8514 2 месяца назад

can you share with the class?

@creativitywithsomefun1614 7 месяцев назад

Just use =SEQUENCE (range of numbers) E.g. =SEQUENCE(1000), gives you a list of numbers from 1-1000😊 though this is also really easy shortcut THANK YOU ❤❤

@youngerin5768 11 месяцев назад

I literally just threw my hands up in success lol.

@bloodtypena 7 месяцев назад

There is no fill series button

@helenatogo9057 7 месяцев назад

I know right, I use to be able to do the way he is showing us but now that option isnt there and is replaced with Copy Cells, Fill Format, Fill without Format and Flash Fill 🤯🤯🤯

@kamaboko1 8 месяцев назад

What if you need a fill for a column that is like 2000 rows. Is there a shortcut for that, or do I have to drag all the way down?

@ExcelCampus 8 месяцев назад

Great question! 😀 Yes, you can double-left-click the bottom-right corner and it will fill all the way down to match the other column's data. Check out the 0:18-0:20 mark in the video. If you need the numbers to increase, check out the 0:30-0:34 mark in the video. I hope that helps you! 😊

@acrobatstar 11 месяцев назад

Thanks a lot brother god bless you my boss didn't know how to explain it and i was struggling

@dfo490 Год назад

Thank you so much got sent to do some stuff for excel and in a bit rusty thank you so much

@LovePeace-wy1ii Год назад

Thank you, I've been searching everywhere.

@FHAZGAMING1 8 месяцев назад

Same Thank you

@TayyabAshiq-ln8xg Год назад

Thanks for the nice video😊😊 it's very helpful😊❤❤❤❤🎉

@ExcelCampus Год назад

Glad it was helpful, @TayyabAshiq-ln8xg 😀

@TayyabAshiq-ln8xg Год назад

@@ExcelCampus l am also happy 🤗😀😊😊

@savagemaster344 Месяц назад

How to fill the cells with same number using the keyboard or shortcut keys, and not the mouse by doing double click. I want to try to keep my hands on the keyboard ad much as possible.

@dennisshanley71 5 месяцев назад

weird how the online EXCEL version used in SHAREPOINT will not even sequence fill after telling it to do so...

@happyandwonder7582 Год назад

How to auto change number? For example 123, change to 132, 213, 231, 321, 312 like this Please help

@zellrang 5 месяцев назад

Fast and straight forward explanation so thanks

@ExcelCampus 5 месяцев назад

You're welcome! 😀

@mtlwgm Год назад

Is there any keyboard shortcuts instead of double clicking?

@cricketskingdom3591 Год назад

Yes, Alt+E+I+S

@sadafmahadi4033 11 месяцев назад

Can it be done? A1 A2 A3 A4 B1 B2 B3 B4 C1 C2 C3 C4 An so on

@ExcelCampus 11 месяцев назад

Yes, this list can be created with a Formula. We'll add this question to our list for future videos. Thanks!

@filipe5153 2 месяца назад

Is it possible to set Excel to autofill a collumn everytime I add a new line?

@TyeGrays Год назад

game changer on how to copy LOL thanks!!

@BharathKumar-tt1ox 4 месяца назад

How to make one perticular name for one specific number with auto fill

@skillpro00000 13 дней назад

this is a simple way but almost nobody concern.

@jonathantienter6874 10 месяцев назад

Saved my sanity! 🎉

@bernardeshun2289 6 дней назад

THANKS BUT MINE IS NOT WORKING WITH ODD NUMBER AND EVEN NUMBERS

@gustavballieuwiesneckgarno3313 4 месяца назад

Can you drag down numbers without using the mouse though?

@c.sam3843 8 месяцев назад

Does it work on google sheets too? I can't find the autofill option like you did in the video.

@sankamil4876 11 месяцев назад

How to unlock the double tap feature? It doesn't work on my device

@helenatogo9057 7 месяцев назад

What if the option auto fill series is not an option, how would you get around this?

@vladimir7759 5 месяцев назад

0:22 I've been at Excel for 8 years, but I only found out about it now lol

@abdemalekabde64 10 месяцев назад

Thank you bro, a lot

@w3y2023 7 месяцев назад

in excel how add mark"+" then add 1 ? thanks

@RahulVaishnav-f3o 9 месяцев назад

Is there any shortcut of that + sign at the corner of the cell.....and I am not talking about Ctrl D....I don't want to select any area but still want to fill the series without using mouse

@ExcelCampus 9 месяцев назад

Nice question! Difficult without selecting an area. Consider converting the range to a table (Ctrl+T), then selecting the entire column (Ctrl+Space). Use Alt+H, F, I ("eye", not L), S. That gets you to the Fill > Series menu. You can either go with the step value listed, use tab to navigate the options, or choose Alt+T to jump to the Trend box. Lastly, press the Enter key. This may not work for your specific case, but it avoids using the mouse.

6 месяцев назад

You are the lifesaver!!!!

@allfurone 20 дней назад

I don't get the "fill series" option.

@nieshpalmore7976 Год назад

Thank you so much ❤ I spent minutes trying to figure this out & ur video took me no time 🎉

@ExcelCampus Год назад

Glad it helped, @nieshpalmore7976! 😀

@muntaser1988 10 месяцев назад

hello Mr campus please help me get hero tools @excelcampus

@Pasdpawn 7 месяцев назад

Whats the shortcut keyboard though?

@ArthurParada 7 месяцев назад

i wonder too

@Pasdpawn 7 месяцев назад

@@ArthurParada ctrl+ D

@ArthurParada 7 месяцев назад

hahahah @@Pasdpawn

@Pasdpawn 7 месяцев назад

@@ArthurParada yes it is

@YAHAYATH786 Год назад

Thanks ❤

@ptoktedia9011 Год назад

thank you sir this video is very helpful

@ExcelCampus Год назад

Thanks for watching, @ptoktedia9011 ! 😀

@deheiligebron 11 месяцев назад

I just stood up and made a little dance!

@RakibSUST 10 месяцев назад

Thanks man,i Learn data science since 1 year but Don't know these double click shortcut

@ExcelCampus 10 месяцев назад

Happy to help. 😀

@Cha-yt3qi 11 месяцев назад

Thank you❤

@Deanamite 10 месяцев назад

how do you fill starting from under to the top ? in example 1 is at the bottom but you want 10 on top

@ExcelCampus 10 месяцев назад

Great question, Dean! One way is to fill 1-10 as shown, then Sort the selection from Largest to Smallest. That will reverse the order. Then, re-apply 1-10 as shown from top to bottom and re-sort if desired. Another way without sorting would be to enter 10 at the top, then from the Ribbon choose Home > Editing > Fill (down arrow) > "Series...". Change "Series in" to Columns, the step value to -1, and the stop value to 1, then select OK. Hope that helps!

@cjnavales1010 8 месяцев назад

how to fill in series numbers backward as you start with #130 to #1. hope you notice

@ExcelCampus 8 месяцев назад

I noticed, CJ! 😀 Use the SEQUENCE function, available in newer Excel versions. =SEQUENCE(130,1,130,-1) yields 130 rows, in 1 column, starting at 130, going backward by 1 ("-1"). Sequence: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-TcFffdPbTfU.html&Also, Fill Series (Alt+H+F+I+S) with Trend checked and a Step value of -1 would work. Fill Series: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-5a9gGhRvflw.html& Hope that helps!

@martinjurik6067 8 месяцев назад

maaaaaaaaan!!!!! that´s so coool I knew there must be a way !! thank you!! you earned subscriber!

@ExcelCampus 7 месяцев назад

Thank you, Martin! 😀

@khurramtalks1 5 месяцев назад

9 is not an odd number 😂

@shivanimaurya3773 9 месяцев назад

Really Helpful ❤ thanks a lot 🎉

@ExcelCampus 9 месяцев назад

You're welcome 😊

@abdulrahmanmuslih141 Год назад

Awesome. Thanks

@ZaneleMondi Год назад

Thank you just used it and it worked. awesome

@ExcelCampus Год назад

Glad it helped, @ZaneleMond! 😀

@paulstephenelogronio7088 10 месяцев назад

❤

@carlosjosedominguezleonard1837 11 месяцев назад

Helped a lot just now❤😂

@ExcelCampus 11 месяцев назад

That's good to know, Carlos! 😀

@Xman-lg7qg Год назад

Any way to do the same reading from another sheet.

@brihzoh.com_2091 9 месяцев назад

Thanks you just helped as am sitting in the office now and it words now I have less job

@ExcelCampus 8 месяцев назад

Glad it was helpful! 😀

@michaeldruce4536 Месяц назад

Thanks Jon. Your knowledge is invaluable. Thank you ☺️

@ExcelCampus Месяц назад

You're welcome! 😀

@suhelgaming3644 Год назад

Good job, really workable

@ExcelCampus Год назад

Thanks! 🙂

@vedang6 11 месяцев назад

thank u very much

@ExcelCampus 11 месяцев назад

You are most welcome! 😀

@AndreaR-wq8dh 10 месяцев назад

Extremely helpful, thank you.

@ExcelCampus 10 месяцев назад

Glad it was helpful! Thanks, Andrea! 😀

@HotspurFC-cu6ny Год назад

How do I do this on a MacBook

@shushanthG456 9 месяцев назад

Tq bro

@DiogoGDF 2 месяца назад

Thank you! Straight to the point!

@BeathaAugustina-v3i 2 месяца назад

Thanks alot god blss you

@ahmadhatami6906 Год назад

Thank you somuchh

@ExcelCampus Год назад

Welcome, @ahmadhatami6906! 😀

@MrDarkogaucho 7 месяцев назад

You are a life save. Thank you very much and you just got new subscriber in me

@ExcelCampus 7 месяцев назад

You're welcome! 😀

@MrDarkogaucho 7 месяцев назад

@@ExcelCampus I do have a question if you don’t mind. Is there a shortcut key to achieve the double clicking to fill the bottom rows without exceeding the last row? Thank you very much in advance?

@prasanthjoel1463 4 месяца назад

thank you so very much. its very helpful...

@ExcelCampus 4 месяца назад

Glad it was helpful! 😀

@salesobspltd3346 2 месяца назад

thank you sir

@richabaranwal8005 11 месяцев назад

Helpful vdo

@ExcelCampus 11 месяцев назад

Thank you 😊

@cricketskingdom3591 Год назад

Thanks man....love from India 🎉❤

@koujipajenago9159 8 месяцев назад

What if i Want 00001,00002?

@ExcelCampus 8 месяцев назад

Great question, Kouji! Use an apostrophe, ' , in front of the entry to indicate text. After typing '00001, Enter, '00002, Enter, select the first two cells. Then, drag the bottom-right corner down as far as you need it to go!