In this Excel video tutorial, we going to see how to create an Excel Drop-Down List that Automatically Updates When you Add New Items. Automatically drop down list in Excel that updates whenever you add new items or new options to your list.

Of course there is many different ways to automatically updates I'm not a validation list in Excel but the methods can change depends on the version of your Excel. I'm using here in this video the indirect function because I'm pretty much sure that this method is going to work in almost all Excel versions.

You can help people work more efficiently in worksheets by using drop-down lists in cells. Drop-downs allow people to pick an item from a list that you create.

A drop down list in Excel is a excellent tool that can help you save time and work more efficiently without needs to manually typing the options that you need to choose, you can basically click in the cell and then choose an option. It's an excellent way to automate tasks in Excel and also to automate repetitive tasks.

#JopaExcel #Dashboard #Excel