How to Create Custom Lists in Excel
To create a custom list in Excel, follow these steps:
Open your Excel spreadsheet and click on the "File" menu.
From the File menu, select "Options" to open the Excel Options dialog box.
In the Excel Options dialog box, select the "Advanced" tab on the left side of the window.
Scroll down to the "General" section and find the "Custom Lists" option.
Click on the "Import" button next to the Custom Lists option.
In the Import List dialog box, type your list items in the box provided, with each item on a new line.
Once you have entered all of your list items, click on the "Import" button.
Your custom list will now be added to the Custom Lists options, and you can use it in your Excel spreadsheet by selecting it from the drop-down list in the Data Validation dialog box.
Note: To use your custom list, you will need to create a Data Validation rule that allows only items from the list to be entered in the cells you want to use the list with. To do this, follow these steps:
Select the cells that you want to use your custom list with.
Click on the "Data" tab in the ribbon, and then click on the "Data Validation" button.
In the Data Validation dialog box, select the "List" option in the Allow drop-down list.
In the Source box, click on the arrow to open the drop-down list and select your custom list.
Click on the "OK" button to save your Data Validation rule.
Now, when you try to enter a value in the selected cells, only items from your custom list will be allowed. If you enter a value that is not in the list, you will see an error message.
And if this article about How to Create Custom Lists in Excel hasn't satisfied you yet, you can watch the video below.
That's all from SmashinGeeks, see you in another article. ^^
Tags:
Article