Excel Data Entry Tricks: Create Custom Lists in Excel For Repetitive Data Entry

Excel Data Entry Tricks: Create Custom Lists in Excel For Repetitive Data Entry

Custom Lists in Excel

In this video, I'll show you how to setup custom lists in Excel to help you use the auto fill handle to improve and quicken your data entry in Excel. This is a super useful tool that was built into Excel and helps you use the fill handle to quickly fill data sets that you use repetitivly.

In my example I show you how you can create a list that you use all of the time and then head over to the file tab in Excel. From there you can then go to options and then advanced.

From here you'll scroll down until you hit Edit Custom Lists. From here you can either import or you can create a custom list right the edit custom list screen.

once you've created your custom list you can then wrie anyword in a cell that is contained in your custom list and the use the fill handle to generate the custom fill sequence.

Other Useful Resources and Links

Custom Lists in Excel

Sort data using a custom list

How to create and fill new custom lists quickly in Excel?

How to Create and Use Your Own Lists in Excel

How to Create Custom Auto Fill Lists in Excel

10 steps to creating a custom list for sorting in Excel

HOW TO USE CUSTOM LISTS WITH EXCEL 2010’S AUTOFILL FEATURE

Where is Custom List in Microsoft Excel 2010 and 2013?

Importing Custom Lists in Excel

EXCEL: USING CUSTOM LISTS WITH THE FILL HANDLE

How to Create a custom list in Excel

[syaoransakura]

Man, you must put an ad in your video. This video is worth many views

[PimpMasterT]

Probably a hopeless situation...but, I'm upgrading to current Excel from 97-2003 Worksheet. The data entry codes are so different and i don't know if I can deal with it, lol. Any tips on how to customize data entry (date, time, currency) the way I'm use to it? Also, the font properties of each column doesn't seem to stay the way i make it (ex: I'll make a column bold and italic and centered, copy and paste and add new info, and it will decide to make it not bold, push to the right etc.). Any tips would be great. Dreading this change...aaaaggghhh.