
- MS Excel Basics
- Excel - Home
- Excel - Getting Started
- Excel - Explore Window
- Excel - Backstage
- Excel - Entering Values
- Excel - Move Around
- Excel - Save Workbook
- Excel - Create Worksheet
- Excel - Copy Worksheet
- Excel - Hiding Worksheet
- Excel - Delete Worksheet
- Excel - Close Workbook
- Excel - Open Workbook
- Excel - Context Help
- Editing Worksheet
- Excel - Insert Data
- Excel - Select Data
- Excel - Delete Data
- Excel - Move Data
- Excel - Rows & Columns
- Excel - Copy & Paste
- Excel - Find & Replace
- Excel - Spell Check
- Excel - Zoom In-Out
- Excel - Special Symbols
- Excel - Insert Comments
- Excel - Add Text Box
- Excel - Undo Changes
- Formatting Cells
- Excel - Setting Cell Type
- Excel - Setting Fonts
- Excel - Text Decoration
- Excel - Rotate Cells
- Excel - Setting Colors
- Excel - Text Alignments
- Excel - Merge & Wrap
- Excel - Borders and Shades
- Excel - Apply Formatting
- Formatting Worksheets
- Excel - Sheet Options
- Excel - Adjust Margins
- Excel - Page Orientation
- Excel - Header and Footer
- Excel - Insert Page Breaks
- Excel - Set Background
- Excel - Freeze Panes
- Excel - Conditional Format
- Working with Formula
- Excel - Creating Formulas
- Excel - Copying Formulas
- Excel - Formula Reference
- Excel - Using Functions
- Excel - Builtin Functions
- Advanced Operations
- Excel - Data Filtering
- Excel - Data Sorting
- Excel - Using Ranges
- Excel - Data Validation
- Excel - Using Styles
- Excel - Using Themes
- Excel - Using Templates
- Excel - Using Macros
- Excel - Adding Graphics
- Excel - Cross Referencing
- Excel - Printing Worksheets
- Excel - Email Workbooks
- Excel- Translate Worksheet
- Excel - Workbook Security
- Excel - Data Tables
- Excel - Pivot Tables
- Excel - Simple Charts
- Excel - Pivot Charts
- Excel - Keyboard Shortcuts
- MS Excel Resources
- Excel - Quick Guide
- Excel - Useful Resources
- Excel - Discussion
How to Auto-Update a Dropdown List in Excel?
A drop-down list is used to choose a single item from the list of data. When we add an item to the source data, we can see that the list will not be updated. A drop-down list is used to select an item from many items, but if we try to add an item to the list, we need to create a new list again. However, there is a way in Excel to auto-update drop-down lists when new data is added to the sheet. This tutorial will help you understand how we can auto-update drop-down lists in Excel.
Auto-Update a Dropdown List in Excel
Here we will use the offset formula when creating the drop-down list. Let us see an uncomplicated process to understand how we can auto-update drop-down lists in Excel. When we create a drop-down list, we do not use any formula, but we can complete this process by using the formula in the general method.
Step 1
Let us consider an Excel sheet from which we can create a drop-down list, and the data will be like the below image.

To create a drop-down list in the general method, click on the list you want to add and click on data validation under Data, then select list, then click on OK to create a drop-down list.

Step 2
Now to create a drop-down list that auto-updates Click on the cell and click on data validation, then in the pop-up list, select "Allow" and enter the formula as =OFFSET($A$2,0,0,COUNTA(A:A)-1) in the source text box and click "OK."

Step 3
Now, every time we enter new data in column A, it will be directly added to the drop-down list, as shown in the below image.

Conclusion
In this tutorial, we used a simple example to demonstrate how we can auto-update a dropdown list in Excel.
- Related Articles
- How to Auto-Populate Other Cells When Selecting Values in an Excel Dropdown List?
- How to Auto-Update a Chart after Entering New Data in Excel?
- How to Autocomplete When Typing in an Excel Dropdown List?
- How to Auto-Number a Column in Excel?
- How to Auto-Protect a Specific Worksheet in Excel?
- How to Auto-Display a Default Value while Deleting a Value in a Drop-Down List in Excel?
- How to Auto-Centre a Checkbox in a Cell in Excel?
- How to Auto-Fit Column Width in Excel?
- How to Auto-Number Merged Cells in Excel?
- How to quickly jump to the adjacent cell based on the selection in an Excel dropdown list?
- How to create a dropdown list using JavaScript?
- How to Auto-Sort Columns by Value in Excel?
- How to select multiple options in a dropdown list with JavaScript?
- How to Auto-Size a Comment Box to Fit Its Content in Excel?
- How to Auto-Number or Renumber after Filter in Excel?
