Look Who it Was Random video

Excel - Using the Excel Fill Handle for a Custom List Such as Bagel Flavors - Episode 432

242 views · Published 18 September 2009 · 1:58 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: The Fill Handle can fill a list of your products if you set up a custom list first. 

Welcome back to another episode of the Learn Excel netcast with Dr. Bill. In this video, we will be discussing a useful tip for filling in lists in Excel using the fill handle. Last week, we talked about how to use the fill handle for filling in dates, but what if you have a list of items that you want to fill in? Well, that's where this tip comes in handy.

Let's say you have a list of departments, customers, employees, or any other type of list that you regularly work with. Instead of manually typing in each item, you can simply type in the first item and use the fill handle to fill in the rest of the list for you. But first, you need to set up your custom list in Excel.

To do this, select your list and go to Tools, then Options, and click on the Custom lists tab. From there, click on the Import button and your list will be added to the bottom of the custom list tab. Now, whenever you need to fill in a list, simply type in the first item and use the fill handle to complete the rest of the list.

This tip can save you time and effort, especially if you have a long list of items to fill in. You can use it for various purposes, such as filling in flavors from your local bagel shop like we did in this video. So, the next time you have a list to fill in, remember this handy tip and make your Excel experience even more efficient.

And don't forget, January 30th is a big day for Excel enthusiasts as it marks the release of Excel 2007. I'll be at Best Buy at 5 a.m. to get my copy, but I'll make sure to be back here by 9 o'clock to bring you another informative netcast. Thanks for watching and we'll see you in the next one!"

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

Table of Contents:

(00:00) Using the fill handle for dates
(00:27) Using the fill handle for custom lists
(00:46) Creating a custom list in Excel
(01:09) Applying the custom list to fill in data
(01:19) Benefits of using this tip in your job
(01:33) Exciting news about Excel 2007 release
(01:43) 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 

This video answers these common search terms:
Adding a list to Excel
Automating list entry in Excel
Creating a custom list in Excel
Excel 2007 features
Excel 2007 release date
Excel netcast
Excel tips for working with lists
How to fill in dates with fill handle
Importing a custom list in Excel
Learn Excel fill handle
Saving time with Excel fill handle
Using fill handle for lists in Excel

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152620/



Sure, Excel can fill in the months of the year. It can fill in the days of the week. It can fill in 1st period, 2nd period, 3rd period. But - what if YOU need to fill in something else? Perhaps a list of departments, customers, co-workers, accounts??? Excel is up to the task. Epsiode 432 will show you how to set up a custom list so that the fill handle can fill in the flavors of bagels from your local coffee shop.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

More from this channel