Edit Custom Lists in Microsoft Excel 2019

Previous post: Sum Cells Text Numbers MS Excel 2016

What is Edit Custom Lists in Excel ?

In Microsoft Excel “Edit Custom Lists…” is extremely powerful and helpful when we need to Create lists for use in sorts and fill sequences.

Where is Edit Custom Lists button located in Excel ?

This option can be found in the Back Stage View. It can be located in File by clicking>Options>Excel Options Dialog Box Pop Up Window will open. Then Advanced>General section>Edit Custom Lists… button.

How Edit Custom Lists option is used in Excel ?

Alright, In Microsoft Excel Custom Lists is basically used for inserting Texts, Numbers etc. inside the blank box area under the List entries option in the Custom List pop up windows box. We need to type the text and then click on the Add button. The entry gets filled in the box. Now again, all the other texts, numbers have to be added in the same manner. A list of entries can be created using this way. Then Click on the OK button. And finally click on the last OK button once more under Excel Options pop up window.

Using Edit Custom Lists in Microsoft Excel Worksheet

After creating a custom list entry in the Edit-Custom-Lists option, we just need to Type the First Entry Text of the list in any cell and then move the arrow to the right below corner of the cell, when the arrow change to the Fill Handle (Black Color +) plus and then click and drag the corner of the cell. In this all the list gets automatically filled in the below cells.

So, Edit Custom Lists button option is real time saver. We can create multiple list entries in the Custom Lists. It can come really handy in every day’s tedious tasks of typing. If a small company has a limited staff, then typing the names of the Employee by using this Custom Lists will be quite awesome and quick. Also if the entries of list have been accurately made, there will no chance of typing mistakes.

Tags: Microsoft Excel Tips