Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.

Dropdowns are useful features that simplify data entry and enforce data validations in spreadsheet software. Creating a dropdown list is easy. And you might have done that already in Excel. But did ...