create a drop-down list Resources

Quickly create drop down lists in Excel with automatic sorting The Drop Down list in Excel is a great automation tool. You can turn any data list into a drop down list which makes it easier to place items in cells. Drop down lists show the data in the same order in which they appear […]

Save time by avoiding repetition and errors Excel is great for lists; sales figures, staff rota’s, stock control, to name a few. But an easy trap to fall into is repetitive error prone data-entry that leads to inaccurate business reporting and lost time in troubleshooting. If you create a drop-down list in Excel, you can avoid […]