How to edit content in a drop-down list from a range in Google Sheets 1. Go to the section of your Google Sheet with the cells that contain the specified range for data validation. 2.

A common use of data validation is to create a drop-down list. Use it to restrict the type of data that users enter into an Excel cell.

Learn how to use a data validation control to allow users to select when to run multiple VBA procedures in Microsoft Excel.