Midgard Wide Logo In White

Tech Tip – Creating Drop-down Lists in Google Sheets

If you use Google Sheets and need to simplify data-entry, adding dropdown lists can really help. Here’s how to add them:

– In Google Sheets, select the cell where you want the dropdown list.

– Click on ‘Data’, select ‘Data Validation’, and select ‘List of items’.

– In the field that loads, type the items you want to include in the dropdown list, separated by commas, and select ‘Save’.


Table of Contents

Leave a Reply

Your email address will not be published. Required fields are marked *


Midgard Short Logo In White


Our Online Portal helps you keep ontop of your IT systems. Designed from the ground up by Midgard IT themselves.