Edit Custom Lists in Microsoft Excel

Previous post: Sum Cells Text Numbers Microsoft Excel

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 do you locate the Custom Lists button in Excel?

You can find this option in the Back Stage View. Navigate and find it by clicking File>Options>Excel Options Dialog Box Pop Up Window will open. Then Advanced>General section>Edit Custom Lists… button.

How do you use the Edit Custom Lists…. option in Excel?

Alright, in Microsoft Excel, you basically use Custom Lists to insert 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. Excel fills the entry in the box.

Now again, you have to add all the other texts and numbers in the same manner. You can create a list of entries 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.
• Then move the arrow to the right below corner of the cell, when the arrow change to the Fill Handle (Black Color +) plus.
• Next, click and drag the corner of the cell. In this step, Excel automatically fills the entire list into the cells below.

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 you make the list entries accurately, there will be no chance of typing mistakes.

See Next Post: Mastering Data Analysis with Microsoft Excel