Auto Fill a Row or Column in Excel with a Custom List of Names.

by

January 29, 2014

Microsoft ExcelIf you work in excel quite a bit, you may be filling out several fields of the same category regularly. Perhaps they are industry standard or specific to your job, but not typical for most people. Well, excel has a neat feature for someone in your shoes.

You can create custom lists, that enable you to insert only the first 2 fields in the list and then drag it across the screen to auto fill the rest. As of now, excel does this automatically with months and dates. But you can just as easily do this with colors, names, or any other hot topic that you may need.

First, create the custom list you have in mind by: Clicking on File, then Options, and then Advanced. Scroll down to the foot of the Advanced Menu. Under the General heading, click Edit Custom Lists and in the Customs List dialog, click New list and enter your list of words with commas separating each field. Click Add and then OK.

To test it, head back to the excel sheet and fill in the first two fields as per your list. Next, select both cells and drag the “fill handle” or the + sign that comes up in the lower right corner of the selection to extend the series downward or left to right. There you have it.

Get back your time and gain from your savvy new trick!

Need help with Microsoft Excel?  Integris can help!  Call (888) 330-8808 or email us at [email protected] and we can help you.

We're Integris. We're always working to empower people through technology.

Keep reading

Managed IT Services St. Paul: 5 Powerful Advantages for Businesses

Managed IT Services St. Paul: 5 Powerful Advantages for Businesses

As a business owner, it's important to make the most of your resources. This includes finding cost-effective solutions for managing and maintaining your company's technology. Keeping a competitive edge in your industry requires secure, modern tech that allows your...

IT Support Minneapolis: Where to Find Top IT Services in Minneapolis

IT Support Minneapolis: Where to Find Top IT Services in Minneapolis

If you’re wondering where to find top IT services in Minneapolis, it’s important to identify providers that offer a wide range of support, have great service and provide solid tech expertise. Comprehensive technology insight is especially important when it comes to IT...

Webinar: Email Security that Doesn’t Suck…

Webinar: Email Security that Doesn’t Suck…

Trustifi and Security 7 present Email Security That Doesn’t Suck.  In today’s age of over-complicated security tools, it is extremely difficult to manage the fine balance between security and productivity.   {% video_player "embed_player" overrideable=False,...