US

Don't embarrass yourself -- make your Excel spreadsheet look more professional with drop-down menus

Data validation in Excel allows you to create drop-down menus right inside individual cells. You can also restrict the types of values entered into different cells. This makes spreadsheets safer to share because you can avoid errors caused by invalid data entries.

Produced by Sara Silverstein

Follow BI Video: On Facebook

Business Insider Emails & Alerts

Site highlights each day to your inbox.

Follow Business Insider Australia on Facebook, Twitter, LinkedIn, and Instagram.