Custom Lists :: How to Add & Use in Custom Sorting

Posted: June 7, 2013 by MaxFraudy in Excel

Many of us use the Auto-fill feature of Excel to fill a range of cells with values like month names and days of week. Do you know how does Excel guess these or how does it know the order of these values? Well, there are certain ‘Custom Lists‘ that have been predefined in Excel. What’s more, you can even define your own.

e.g. Let’s say you need to work with your team members data a lot and you need to type (or copy) your team members’ names over and over again for each new report. You could save your time by creating a Custom List of all names and just auto-fill. Here’s how it can be done:

  1. Click the Office button -> Excel Options -> Popular tab -> Edit Custom Lists
    Custom Lists - Edit

    Custom Lists – Edit

    Custom Lists - Add

  2. In the dialog box that pops up, either select the range where your data is and click Import or type in the values in the box above and click Add.
  3. Done!

Now this list will be available for auto-fill et al like the other preloaded lists. This list will be available in all workbooks on the computer where it is saved.

When Can I Use Custom Lists?

Auto-fill : like discussed above.

Sorting: You can use these custom lists to sort your data, let’s say on a High, Medium, Low. To do so, go to Data tab -> Sort & Filter group -> Sort. Select the list according to which you wish to sort.

Custom Lists - Sorting

Custom Lists – Sorting


Share your thoughts/feedback

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s