• Latest
Learn How to Create Dropdown List in Google Sheets

Learn How to Create Dropdown List in Google Sheets

March 17, 2021
Museveni, Samia Hold Talks at State House Entebbe, Agree to Fast-Track EACOP and SGR

Museveni, Samia Hold Talks at State House Entebbe, Agree to Fast-Track EACOP and SGR

November 18, 2026
Vandalism of King of Tooro Poster in Kyegegwa Sparks Outrage

Vandalism of King of Tooro Poster in Kyegegwa Sparks Outrage

November 18, 2026
VINAStech Advert

Rooney reveals he contemplated suicide during Manchester United career

November 17, 2026
Kampala, Wakiso to get 3.3 million mosquito nets in final distribution wave

Kampala, Wakiso to get 3.3 million mosquito nets in final distribution wave

November 17, 2026
Amuriat: We are ready for Kikuube By-election

FDC sets conditions for national dialogue

November 17, 2026

16 Days of Activism: A Call to Confront Rape and Domestic Violence in Wakiso

November 17, 2026
Teacher shortage stretches government schools within and around Kampala

Teacher shortage stretches government schools within and around Kampala

November 17, 2026

From Campus to Content Creation: Makerere student turns passion into a way to pay tuition

November 17, 2026
Young African leaders urged to turn Pan-Africanism into action at UBUMWE Summit 2026

Young African leaders urged to turn Pan-Africanism into action at UBUMWE Summit 2026

November 17, 2026

Police officer, teacher remanded over forged UNEB letters

November 16, 2026
Move beyond account ownership, BOU tells banks

Move beyond account ownership, BOU tells banks

November 16, 2026
Crime drops by 10.2% in 2025, Police report

IGP moves police spokespersons across several regions

November 16, 2026
  • About Us
  • Internship
  • Contact Us
Wednesday, November 18, 2026
Parrots Media
No Result
View All Result
  • Login
  • News
    Vandalism of King of Tooro Poster in Kyegegwa Sparks Outrage

    Vandalism of King of Tooro Poster in Kyegegwa Sparks Outrage

    Amuriat: We are ready for Kikuube By-election

    FDC sets conditions for national dialogue

    16 Days of Activism: A Call to Confront Rape and Domestic Violence in Wakiso

    Police officer, teacher remanded over forged UNEB letters

    Move beyond account ownership, BOU tells banks

    Move beyond account ownership, BOU tells banks

    Before changing jobs, read the fine print

    Before changing jobs, read the fine print

    Trending Tags

  • Climate Change
  • Business
  • Science and Technology
  • Sports and Entertainment
  • Business
  • Others
    • Education
    • Lifestyle
    • Religion
    • Opinions
  • News
    Vandalism of King of Tooro Poster in Kyegegwa Sparks Outrage

    Vandalism of King of Tooro Poster in Kyegegwa Sparks Outrage

    Amuriat: We are ready for Kikuube By-election

    FDC sets conditions for national dialogue

    16 Days of Activism: A Call to Confront Rape and Domestic Violence in Wakiso

    Police officer, teacher remanded over forged UNEB letters

    Move beyond account ownership, BOU tells banks

    Move beyond account ownership, BOU tells banks

    Before changing jobs, read the fine print

    Before changing jobs, read the fine print

    Trending Tags

  • Climate Change
  • Business
  • Science and Technology
  • Sports and Entertainment
  • Business
  • Others
    • Education
    • Lifestyle
    • Religion
    • Opinions
No Result
View All Result
Parrots Media
No Result
View All Result

Learn How to Create Dropdown List in Google Sheets

Watera by Watera
March 17, 2021
in Uncategorized
0
Learn How to Create Dropdown List in Google Sheets
0
SHARES
16
VIEWS
Share on FacebookShare on X

READ ALSO

Museveni, Samia Hold Talks at State House Entebbe, Agree to Fast-Track EACOP and SGR

Vandalism of King of Tooro Poster in Kyegegwa Sparks Outrage

There are many things you can do on Google Sheets, and most of these things revolve around sorting through large amounts of data and making it easier to analyze or work with. One of the many ways to make data sorting easier in Google Sheets is to create a dropdown list.

A dropdown list offers a defined list of options for a particular cell in a sheet such that if the value for that cell must be taken from the list of options in the dropdown. These options would have been predefined by the sheet owner.

In this post, we’ll show you how to create a dropdown list in Google Sheets. This is a great hack for defining the values you want a cell to contain. Read through.

Create Dropdown List on Google Sheets

Follow the steps below to create a dropdown list on any cell in Google Sheets.

  • The first step to take is to open the Google Sheets document and select the cell you want to create a dropdown for.
create dropdown list google sheets
  • Click on the Data option and select Data validation.
create dropdown list google sheets
  • Choose either “List from a range” or “List of items” under the Criteria option. List from a range means you want a list of values selected from other cells in that same sheet or a different sheet. While List of items is a list of predetermined items that you input. These can be text or numbers.
create dropdown list google sheets
  • If you choose List from a range, insert the cell range from which you want the values selected. For the List of items option, type in the values you want to be shown and separate them with commas.
  • Make sure the Show dropdown list in cell option is ticked. This makes sure that the values are shown in the cell.
  • Also, choose what happens when a value that isn’t in the list is entered into the cell. It can either be Show warning or Reject input. The former allows wrong data entry but shows a warning while the latter does not allow wrong data input.
  • You can also Show validation help text to let people know what they can choose in the cells.
  • Click Save and you’re done.

After going through this process, you should then visit the selected cell(s) and click on the downward pointing arrow. It’ll show a dropdown list of the value you had predetermined. Like the one below.

create dropdown list google sheets

To remove or edit any of the options in the dropdown list, return to Data validation and edit. You can also click the Remove validation button to delete the list entirely. Remember to select the cell on which you added the list in the first place.

Drop a comment below if you got stuck in any of the steps above. We’re very happy to help out.

Tags: AfSHG

Related Posts

Museveni, Samia Hold Talks at State House Entebbe, Agree to Fast-Track EACOP and SGR
Business

Museveni, Samia Hold Talks at State House Entebbe, Agree to Fast-Track EACOP and SGR

November 18, 2026
Vandalism of King of Tooro Poster in Kyegegwa Sparks Outrage
News

Vandalism of King of Tooro Poster in Kyegegwa Sparks Outrage

November 18, 2026
Health

Rooney reveals he contemplated suicide during Manchester United career

November 17, 2026
Kampala, Wakiso to get 3.3 million mosquito nets in final distribution wave
News

Kampala, Wakiso to get 3.3 million mosquito nets in final distribution wave

November 17, 2026
Amuriat: We are ready for Kikuube By-election
News

FDC sets conditions for national dialogue

November 17, 2026
News

16 Days of Activism: A Call to Confront Rape and Domestic Violence in Wakiso

November 17, 2026
Next Post

Controversial Magufuli dies aged 61

POPULAR NEWS

Catholic Priest Dies During Holy Mass

Catholic Priest Dies During Holy Mass

February 6, 2026
Men Sucking Women’s Breasts Doesn’t Prevent Cancer, Oncologists

Men Sucking Women’s Breasts Doesn’t Prevent Cancer, Oncologists

October 17, 2025
Minister Amongi, Akena Scrapped from EC Voters’ Register Oops

Minister Amongi, Akena Scrapped from EC Voters’ Register Oops

September 3, 2025
Bubangizi SS Student Dies Hours to UACE Exams

Bubangizi SS Student Dies Hours to UACE Exams

November 9, 2025
Catholic Priest Speaks Out Against Museveni and Son’s Leadership

Catholic Priest Speaks Out Against Museveni and Son’s Leadership

February 16, 2025

EDITOR'S PICK

Gov’t spoiled Gen Lokech military record at the nineth hour, Bobi

August 22, 2021
UJA suspends Word Press Freedom Day activities over death of emeritus president.

UJA suspends Word Press Freedom Day activities over death of emeritus president.

April 30, 2021
Old Boys to Rekindle Makobole High School

Old Boys to Rekindle Makobole High School

April 4, 2023
Police Investigate Alleged Aggravated Defilement of 4-Year-Old Girl

Man Arrested Over Alleged Defilement of Primary Six Pupil in Kazo

August 6, 2026
VINAStech advert VINAStech advert VINAStech advert
ADVERTISEMENT

About

Parrots Media

A Public Relations and Media Services Company registered and licensed to operate in Uganda and the Great Lakes Region.

Follow us

Categories

  • Business
  • BUSINESS REPORTS
  • CLIMATE ACTION REPORTS
  • Climate Change
  • COMMUNITY REPORTS
  • Education
  • Entertainment
  • FEATURES
  • Health
  • Lifestyle
  • News
  • News
  • Obituary
  • OBITUARY
  • Opinions
  • RELIGION
  • Religion
  • Science and Technology
  • Sports
  • Sports and Entertainment
  • TOURISM

Recent Updates

  • Museveni, Samia Hold Talks at State House Entebbe, Agree to Fast-Track EACOP and SGR
  • Vandalism of King of Tooro Poster in Kyegegwa Sparks Outrage
  • Rooney reveals he contemplated suicide during Manchester United career
  • Kampala, Wakiso to get 3.3 million mosquito nets in final distribution wave
November 2026
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
30  
« Oct    
  • About Us
  • Internship
  • Contact Us

© 2025 Parrots Media | Website Designed and Maintained by VINAStech

No Result
View All Result
  • Parrots Media
  • News
  • Business
  • Science and Technology
  • Sports and Entertainment
  • Lifestyle
  • Others
    • Climate Change
    • Education
    • Religion
    • Opinions

© 2025 Parrots Media | Website Designed and Maintained by VINAStech

Welcome Back!

Login to your account below

Forgotten Password?

Retrieve your password

Please enter your username or email address to reset your password.

Log In

You cannot copy content of this page