Javatpoint Logo
Javatpoint Logo



Excel custom records permit clients to make their own arrangements of values to use in different accounting sheet undertakings. These rundowns can be useful for filling cells with dreary information, like days of the week, months, or some other modified arrangement. By characterizing a custom rundown, clients can rapidly autofill cells with their ideal succession by just hauling the fill handle. This element saves time and guarantees consistency in information passage. Custom records can be made and overseen inside Excel's choices, furnishing clients with adaptability and productivity in coordinating and contributing information as per their particular requirements.

Excel has a few valuable elements that permit you to save time and be much more useful in your everyday work. One such valuable (and less-known) highlight in the Custom Records in Excel. Presently, before I get to how to make and utilize custom records, let me initially make sense of what's the big deal about it.

  • Assume you need to enter numbers the month names from Jan to Dec in a section. How might you make it happen? And negative, doing it physically isn't a choice.

One of the quickest ways is have January in a phone, February in a neighboring cell and afterward utilize the fill handle to drag and let Excel consequently fill in the rest. Excel is sufficiently to understand that you need to fill the following month in every cell in which you drag the fill handle.

This Instructional exercise Covers:

  • The most effective method to Make Custom Records in Excel
  • Make Your Own Arranging Measures Utilizing Custom Records
  • A few Models Where you can Utilize It

How to Create Custom Lists in Excel:

Naturally, Excel as of now has some pre-taken care of custom records that you can use to save time.

For instance, assuming you enter 'Mon' in one cell 'Tue' in a nearby cell, you can utilize the fill handle to fill the other days. On the off chance that you broaden the determination, continue to drag and it will rehash and allow you the day's name in the future.


The following are the custom records that are as of now in-worked in Excel. As may be obvious, these are for the most part days and month names as these are fixed and won't change.

Presently, assume you need to make a rundown of divisions that you frequently need in Excel, you can make a custom rundown for it. Along these lines, the following time you want to get every one of the divisions names in one spot, you don't have to scavenge through old documents. You should simply type the initial two in the rundown and drag.

The following are the moves toward make your own Custom Rundown in Excel:

  • Click the File tab
  • Click on Choices. This will open the 'Excel Choices' exchange box.
  • Click on the High-level choice in the left-sheet
  • In the Overall choice, click on the 'Alter Custom Records' button (you might need to look down to get to this choice)
  • In the Custom Records exchange box, import the rundown by choosing the scope of cells that have the rundown. On the other hand, you can likewise enter the name physically in the Rundown Passages box (isolated by comma or each name in another line)

When you click on Add, you would see that your rundown currently turns into a piece of the Custom Records. Custom Records turns into an inbuilt rundown in the event that you have a huge rundown that you need to add to Succeed, you can likewise involve the Import choice in the discourse box.

NOTE: You can likewise make a named range and utilize that named range to make the custom rundown. To do this, enter the name of the named range in the 'Import list from cells' field and snap alright. The advantage of this is you can change or grow the named range and it will consequently get changed as the custom rundown.

Since you have the rundown in Excel backend, you can utilize it very much like you use numbers or month names with Autofill (as displayed underneath).


While it's perfect to have the option to rapidly get these custom list names in Excel by doing a straightforward simplified, there is something considerably impressive that you can do with custom records (that is what's going on with the following segment).

Create Your Own Sorting Criteria Using Custom Lists:

Something incredible about custom records is that you can utilize it to make your own arranging models. For instance, assume you have a dataset as displayed beneath and you need to sort this in view of High, Medium, and Low.


Assuming you sort sequentially, it would screw the in sequential order request (it will give you High, Low, and Medium and not High, Medium, and Low).

This is where Custom Records truly sparkle.

You can make your own rundown of things and afterward utilize these to sort the information. Along these lines, you will get every one of the Great qualities together at the top followed by the medium and low qualities.

When you have the custom rundown made, you can utilize the beneath moves toward sort in light of it:

  • Select the whole dataset (counting the headers). Click the Data tab.
  • In the Sort and Channel bunch, click on the Sort symbol. This will open the Sort exchange box.

In the Sort exchange box, make the accompanying determinations:

  • Sort by Section: Need
  • Sort On: Cell Values
  • Request: Custom Records. At the point when the exchange box opens, select the arranging rules you need to utilize and afterward click on alright.
  • Click ok

The above advances would quickly sort the information utilizing the rundown you made and utilized as models while arranging (High, Medium, Low in this model).


Some Examples Where you can Use Custom Lists:

The following are a portion of the situations were making and utilizing custom records can save you time:

  • Assuming you have a rundown that you really want to enter physically (or duplicate glue from another source), you can make a custom rundown and utilize that all things considered. For instance, this could be office names in your association, or item names or areas/nations.
  • On the off chance that you're an instructor, you can make a rundown of your understudy names. Like that, when you are reviewing them the following time, you don't have to stress over entering the understudy names physically or duplicate sticking it from another sheet. This additionally guarantees that there are less possibilities of blunders.
  • At the point when you really want to sort information in light of models that are not in-worked in Excel. As shrouded in the past segment, you can utilize your own arranging standards by making a custom rundown in Excel.


Excel custom records are an important component that upgrades effectiveness and consistency in information passage undertakings. By permitting clients to characterize their own successions of values, like days of the week, months, or some other modified grouping, Excel custom records smooth out the most common way of filling cells with monotonous information.

This element saves time and decreases the probability of blunders by guaranteeing consistency across datasets. Whether overseeing plans, arranging stock, or some other assignment requiring dull information passage, custom records engage clients to work all the more really inside Excel. Embracing custom records can altogether improve efficiency and information the executives' capacities inside the Excel climate.

Youtube For Videos Join Our Youtube Channel: Join Now


Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Trending Technologies

B.Tech / MCA