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.

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