# How to edit drop-down lists in Excel

Theoretically, once you create a [drop-down list](https://www.ionos.co.uk/digitalguide/online-marketing/online-sales/creating-an-excel-drop-down-list/) in Excel, it can be used indefinitely. That said, at some point, you may wonder ‘How do I edit a drop-down list in Excel?’. We explain what options you have for editing drop-down lists.

## Step-by-step instructions for editing drop-down lists in Excel

Every drop-down list in Excel requires you to compile a list of the entries in the same workbook. This list should ideally be **formatted as a table** so that when you change the entry in a table cell, this change is immediately visible in the linked drop-down list. It is a different matter when you want to insert or delete cells. For these changes to also be visible in the drop-down list, the linked area has to be adapted.

Note The following instructions apply to the Excel version in Microsoft 365 as well as the Excel versions 2021, 2019 and 2016.

To do this, select the cell (or cells) using the drop-down function and then follow these steps:

1. Go to **Data Validation** in the **Data** menu.
2. Under **Source**, reconfigure the area for your drop-down list. You can do this by either directly typing in the new reference or highlighting it using the select function.
3. The changes will then also be visible in the drop-down list.

[![Image: Selection option for expanding Excel drop-downs using Data Validation](https://www.ionos.co.uk/digitalguide/fileadmin/_processed_/a/0/csm_edit-excel-dropdown_bc82629ef7.webp "Selection option for expanding Excel drop-downs using Data Validation")](https://www.ionos.co.uk/digitalguide/fileadmin/DigitalGuide/Screenshots_2023/edit-excel-dropdown.png) If you want to expand or shorten the drop-down list, this must be changed in the ‘Data Validation’ section. ## How to change error alerts and input messages in Excel drop-down lists

Data Validation provides even more options for editing drop-down lists in Excel. Simply click on the other tabs in the **Data Validation** section:

**Input Message:** The input message feature allows you to make comments. This is especially important if third parties will be working with the file. You can use a comment to explain how to properly use the file in detail or give more information about the drop-down list. If the user clicks on the cell with the drop-down list, the comment appears in a yellow box.

[![Image: Window for editing the input message](https://www.ionos.co.uk/digitalguide/fileadmin/_processed_/1/b/csm_excel-dropdown-input-message_8c503ea689.webp "Window for editing the input message")](https://www.ionos.co.uk/digitalguide/fileadmin/DigitalGuide/Screenshots_2023/excel-dropdown-input-message.png) Provide other users with information relating to the drop-down list. **Error Alert:** The error alert menu gives you the possibility to provide feedback on incorrect entries. In principle, a drop-down list prevents invalid entries from being used because users are meant to select the value they want from the list. However, other entries that are not on the list can be made through the formula bar. If a value is written in the row and is not in the list, an error will occur. The error alert gives you the option of explaining to other users what the correct procedure is to follow. You can also choose from three different types of error alert:

- **Stop**: This style of error alert is displayed, and the incorrect entry is not permitted.
- **Warning**: A warning error alert is displayed, and the user is given the option to allow or undo the error.
- **Information**: This type of error alert is displayed, and the incorrect entry is adopted in the cell anyway.

[![Image: Menu for creating an error alert](https://www.ionos.co.uk/digitalguide/fileadmin/_processed_/2/6/csm_excel-dropdown-error-alert_c16ca83590.webp "Menu for creating an error alert")](https://www.ionos.co.uk/digitalguide/fileadmin/DigitalGuide/Screenshots_2023/excel-dropdown-error-alert.png) Make sure that an error alert is displayed when someone uses the drop-down list incorrectly. ## How to adapt the appearance of drop-down lists in Excel

The appearance of drop-down lists in Excel can also be adapted. Like with any other cell, you start by right-clicking the cell containing the drop-down list. Then select *Format Cells* in the context menu. Here, you can **adapt the cell’s appearance**:

- **Number**: If your drop-down list should include numbers, you can change how these are displayed.
- **Alignment**: If the text isn’t going to be aligned horizontally, this option lets you change the alignment and direction of the text.
- **Font**: The font, font style and font size can be adapted in this menu item.
- **Border**: If you want to make the drop-down list stand out with a border, you can change the size and appearance of the line here.
- **Fill**: Filling the cell with a colour of your choice is another way you can draw attention to it.

[![Image: Editing the style of an Excel drop-down list](https://www.ionos.co.uk/digitalguide/fileadmin/_processed_/c/e/csm_excel-dropdown-adapting-appearence_b8b4bb29c4.webp "Editing the style of an Excel drop-down list")](https://www.ionos.co.uk/digitalguide/fileadmin/DigitalGuide/Screenshots_2023/excel-dropdown-adapting-appearence.png) You can also change the appearance of an Excel drop-down list via ‘Format Cells’.  Tip In the Digital Guide, you can also read how to [create Excel drop-down lists](https://www.ionos.co.uk/digitalguide/online-marketing/online-sales/creating-an-excel-drop-down-list/) or how to work on your spreadsheets more efficiently with [Excel shortcuts](https://www.ionos.co.uk/digitalguide/online-marketing/web-analytics/excel-shortcuts/). Also take a look at our article on [Google Sheets drop-down lists](https://www.ionos.co.uk/digitalguide/online-marketing/online-sales/drop-down-lists-in-google-sheets/) if you work with Google’s online spreadsheet application.


This is a markdown version of: [https://www.ionos.co.uk/digitalguide/online-marketing/online-sales/editing-an-excel-drop-down-list/](https://www.ionos.co.uk/digitalguide/online-marketing/online-sales/editing-an-excel-drop-down-list/) for AI/LLM consumption.