Updating cell in excel
Microsoft Excel spreadsheet software is perhaps one of the most useful tools launched by any company in the history of modern computing.
The program also offers efficient ways to combine and summarize data from multiple files, also known as worksheets.
But if you add new data in the cell below the original data range, the relative drop down list cannot be updated.
Here I will tell you a good way to auto update the drop down list when adding new data to the original data.
Excel drop-down lists, like those found on Web pages, help you view large amounts of data in a small area.
They are also useful for limiting the choices an Excel spreadsheet user can make when editing a cell.