Microsoft Excel Tutorial - Trick to use Fill Series to quickly fill 100,000 numbers in Excel.
Welcome to the MrExcel netcast, where we bring you the best Excel tips and tricks to help you become an Excel pro. In this episode, we will be discussing how to use the Fill Series feature to quickly fill from 1 to 100,000. This is a game-changing trick that will save you hours of manual work.
If you've been following our previous episodes, you may have learned about the CTRL key trick to extend numbers using the fill handle. But what if you need to fill from 1 to 100,000? That's where this trick comes in. I learned this from my professor at the University of Western Michigan during a live power Excel seminar. And let me tell you, it's a game-changer.
To use this trick, simply type the number 1 in any blank cell, select it, and then go to the Home tab and click on Fill, followed by Series. Make sure to change the last number to 100,000 and click OK. And just like that, your numbers are filled in seconds. It's a beautiful, beautiful, beautiful trick that will save you a ton of time and effort.
But what if you need to fill a hundred thousand names instead of numbers? Don't worry, we've got you covered. In a previous episode, we showed you how to create a custom list with names like Apple, Banana, Cherry, and so on. Now, to fill a hundred thousand of those names, simply type the first name, then type A100002 in the name box and press Shift+Enter. This will select the cell and allow you to fill from the current cell. Then, go to Fill, followed by Fill Series, and click OK. And just like that, you have a hundred thousand names filled in no time.
To recap, this trick is a lifesaver when it comes to filling a large range of numbers or names. Simply type the starting number or name, go to Fill, then Series, and make sure to change the last number or name. And don't forget the cool trick using Shift+Enter in the name box. It's just one of the many tips and tricks you can find in our book "MrExcel XL", which is filled with over 40 Excel tips, cartoons, cocktails, tweets, and jokes.
We would also like to give a special thanks to the Accounting Department of Western Michigan University for sharing this amazing trick with us. And of course, thank you for tuning in to another netcast from MrExcel. Don't forget to click the "i" in the top-right corner to purchase our book and stay tuned for more Excel tips and tricks in our future episodes. See you next time!
Buy Bill Jelen's latest Excel book: mrexcel.com/products/latest/
You can help my channel by clicking Like or commenting below: mrexcel.com/like-mrexcel-on-youtube/
Table of Contents:
(00:00) Using Fill Series to Fill From 1 to 100,000
(00:19) The CTRL key trick for extending numbers
(00:29) Fill Series dialog
(00:55) Filling a custom list of 100,000 flavors
(01:26) Recap of concepts in the video
(01:49) Shift+Enter trick in the name box
(01:59) Clicking Like really helps the algorithm
#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial #excelhacks #excelfillhandle #excelfillseries
This video answers these common search terms:
how to autofill series of numbers in excel
how to fill number series in quickly excel
how to quickly fill series of numbers excel
how to automatically fill series in excel
what is auto fill series in excel
where is the fill series in excel
how to fill a column in excel in a series
how to fill a series of numbers in excel
how to fill alphanumeric series in excel
how to fill down number series in excel
how to fill excel series numbering
how to fill in series in excel
how to fill number series excel
how to fill series in excel
how to fill series in excel shortcut
where is fill series in excel
where is fill series on excel
how to autofill series in excel
how to use autofill in excel to create a series
which is the best way to fill out a series of cells with a series of numbers in excel
how to fill a sequence in excel
how do you fill sequence in excel
how to autofill number sequence in excel
easy way to fill a sequence in excel
Use the Fill Series dialog in Excel to fill from 1 to 100,000 in a few clicks. Also in this episode:
It would take a long time to fill 1 to 100,000
Even if you use the Ctrl key while dragging the fill handle
Type a starting number in a cell
Home, Fill, Series…
Change from Rows to Columns
Click OK
You can Fill from a series
Cool trick with Shift+Enter in Name Box
Join the MrExcel Message Board discussion about this video at mrexcel.com/board/threads/1153807/
- Excel - How To Fill A Number Series In Quickly In Excel - Episode 1979 ( Download)
- Excel - How To Fill From A Custom List In Excel - Episode 1978 ( Download)
- Excel Video 258 Fill Series ( Download)
- Excel numbering from 1 to 100000 - 1 second solution⚡ (even dates!) ( Download)
- Excel Tutorial - Fill in a series of data ( Download)
- Fill series in Excel ( Download)
- Excel - How to Interpolate Between 2 Numbers Using Fill Series (feat. Bob Umlas) - Episode 2398 ( Download)
- Excel - Amazing Way to Add AutoSum to Total Row and Total Column at Once - Episode 1980 ( Download)
- Filling Series in Ms Excel | full tutorial | Quickly fill 100k No. in just second ( Download)
- Learn How to Auto-Fill Numbers in Microsoft Excel Without Having to Type Them All - PC User Nerd ( Download)
- Fill Series from 1 to 1000 instantly #exceltips #exceltricks #excel ( Download)
- Excel - How To Select Many Ranges In Excel No Mouse - Shift+F8 Add to Selection - Episode 1945 ( Download)
- Excel - Running Total AutoFill: Episode 1502 ( Download)
- Excel Prime Numbers Galore: Generate Prime Numbers In Excel - Episode 2309 ( Download)
- Learn Excel - Video 155 Fill series - Deal with Dates ( Download)
