Some Excel features are buried in menus and settings. Others are so simple that discovering them feels embarrassing. These seven tricks take seconds to learn but can make you wonder why nobody ...

Drop-down lists in Microsoft Excel (and Word and Access) allow you to create a list of valid choices that you or others can select for a given field. This is especially useful for fields that require ...