How to Auto Populate the Date in Excel. When you're setting up a Microsoft Excel spreadsheet that contains date information, you'll speed your task if you let Excel do the tedious work of filling ...

Populating a dropdown with a dynamic list is easy thanks to Microsoft Excel’s UNIQUE() dynamic array function.