Cookies on the Business Insider India website

Business Insider India has updated its Privacy and Cookie policy. We use cookies to ensure that we give you the better experience on our website. If you continue without changing your settings, we\'ll assume that you are happy to receive all cookies on the Business Insider India website. However, you can change your cookie setting at any time by clicking on our Cookie Policy at any time. You can also see our Privacy Policy.

How To Add Drop-Down Menus To Your Excel Spreadsheet

Sara SilversteinFeb 20, 2014, 19:20 IST

Your browser doesn't support HTML5 video.

kalturavideoplaceholder

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.