Google Workspace

G Suite Pro Tip: how to create a dropdown list in Google Sheets

Happy Spreadsheet Day! Today marks the release of the first-ever electronic spreadsheet from a company called Visicalc. Nearly 40 years later, spreadsheets are still an essential tool to help businesses crunch—and share—their data.

To commemorate, we’re releasing another G Suite Pro Tip to help you master the art of spreadsheet organization using two key features in Google Sheets: Data Validation and Conditional Formatting.

With this tip, you’ll be able to make your spreadsheet look top-notch by adding dropdown lists to cells and color-coding tasks.

Breaking it down

In this G Suite Pro Tip, we break down how to use two features in Sheets.

First, Data Validation…

Data Validation is a feature that’s most commonly used to add dropdown lists into cells within Sheets. Let’s say you want a column within your spreadsheet to track the status of a project. You might use data validation to create dropdown options within a cell that say “Not yet started,” “In progress” or “Ready.”

Select the cells, then choose Insert > Dropdown or Data > Data validation > Add rule. Under Criteria, choose Dropdown and add the options one at a time. You can also choose Dropdown from a range if the options are already in the sheet.

What some folks don’t realize is that data validation can be used for so much more than creating dropdown lists. For example, you can:

  • Track upcoming work. Use a date validation rule for the due-date column and a separate conditional formatting rule to highlight dates that need attention.
  • Add custom meanings to checkboxes. Select the cells and open Data > Data validation. Choose Checkbox under Criteria, then select Use custom cell values to set values for the checked and unchecked states.
  • Keep entries consistent. Data validation can reject entries that do not match the rule or show a warning, depending on your settings. To control who can edit a formula or range, use protected sheets and ranges.

Second, Conditional Formatting…

Conditional formatting is a tool that can help you color-code your spreadsheets—like if you want to auto-assign a color to a cell-based on specific criteria.

Building on the project tracker example, let’s say you want to remind team members to take action by making anything that’s categorized as “In progress” appear in yellow within your Sheet.

You can select the cell or column you want to assign colors to and go to Format > Conditional Formatting. It will open up a side panel with options.

Under “Format cells if…” select from a number of options (we recommend “text is exactly”). Type in the text that you’d like to auto-change color for. In this instance, anytime someone selects “In progress” from the dropdown options, you can choose to make the color appear yellow in the cell.

Whether it’s mastering macros or centralizing your data, we want to help you become a G Suite Pro. Learn more tips on our YouTube channel.

Source: https://goo.gl/6kqHRs

Affiq Fadzil

Recent Posts

AuditGlance for Google Workspace or Google Cloud: which fits your question?

A question about shared Drive files needs a different review from a question about an…

2 weeks ago

5 Proven Crucial Safeguards to prevent GWS data leaks

Google Workspace makes it easy to share files and collaborate. Review sharing settings, account access…

3 months ago

Unleashing Enterprise Intelligence: 5 Proven Exciting NotebookLM training Breakthroughs

In the modern hyper-competitive B2B landscape, corporate data is growing at an unprecedented rate.Yet, most…

3 months ago

Business Intelligence Navigator: scope a STAX knowledge workflow

When an experienced employee leaves, colleagues may lose the context behind a procedure or a…

3 months ago

5 Proven Devastating Cloud Security Mistakes Exposed

Reviewed and updated: 23 October 2026. A cloud-security review should help your team answer three…

3 months ago

5 Outstanding Smart Alibaba Cloud Solutions Secrets

Is your enterprise struggling to keep its monthly cloud infrastructure expenses under control? In today's…

4 months ago