You can also select a whole column. 3. Click on the "Data" tab in the top menu so the Data menu ribbon appears. 4. Click on the arrow next to "Data Validation." 5. Choose "Data Validation" from ...