• Latest
Learn How to Create Dropdown List in Google Sheets

Learn How to Create Dropdown List in Google Sheets

March 17, 2021
Nine Cleared for Amolatar LCV Chairperson Race as Campaigns Begin

Nine Cleared for Amolatar LCV Chairperson Race as Campaigns Begin

September 6, 2025
Rubirizi Grapples With Alarming Increase in Suicide Cases

Three Die in Suspected Electrocution at Bushenyi Crusade

September 6, 2025
VINAStech Advert
“No More Tolerance”: Museveni Blasts Judges Over Bail for Criminals

Museveni defends Karangwa on ethnicity

September 5, 2025
Bridging the Protection Gap in Uganda’s Green and Agricultural Economy

How African leaders can drive the real change at the Africa Climate Summit II

September 5, 2025
NWSC Restores Normal Water Supply to Gulu After Completion of Works on Karuma-Gulu Main Transmission

NWSC Restores Normal Water Supply to Gulu After Completion of Works on Karuma-Gulu Main Transmission

September 5, 2025
28 Suspected Ebola Cases, 15 Deaths Reported in Congo

28 Suspected Ebola Cases, 15 Deaths Reported in Congo

September 5, 2025
Rwandan Gospel Artist Musabyimana Gloriose, Known as Gogo, Passes Away at 36

Rwandan Gospel Artist Musabyimana Gloriose, Known as Gogo, Passes Away at 36

September 4, 2025

3,278 Children Get Cancer in Uganda Each Year, UCI

September 4, 2025
30 years old man Commits Suicide By Hanging in Kasese

30 years old man Commits Suicide By Hanging in Kasese

September 4, 2025
EC Refutes Claims of Akena, Amongi Deletion

EC Refutes Claims of Akena, Amongi Deletion

September 3, 2025
Minister Amongi, Akena Scrapped from EC Voters’ Register Oops

Minister Amongi, Akena Scrapped from EC Voters’ Register Oops

September 3, 2025

Africa must unite for real climate solutions at the Second Africa Climate Summit

September 3, 2025
  • About Us
  • Internship
  • Contact Us
Sunday, September 7, 2025
Parrots Media
No Result
View All Result
  • Login
  • News
    Nine Cleared for Amolatar LCV Chairperson Race as Campaigns Begin

    Nine Cleared for Amolatar LCV Chairperson Race as Campaigns Begin

    Rubirizi Grapples With Alarming Increase in Suicide Cases

    Three Die in Suspected Electrocution at Bushenyi Crusade

    “No More Tolerance”: Museveni Blasts Judges Over Bail for Criminals

    Museveni defends Karangwa on ethnicity

    NWSC Restores Normal Water Supply to Gulu After Completion of Works on Karuma-Gulu Main Transmission

    NWSC Restores Normal Water Supply to Gulu After Completion of Works on Karuma-Gulu Main Transmission

    Rwandan Gospel Artist Musabyimana Gloriose, Known as Gogo, Passes Away at 36

    Rwandan Gospel Artist Musabyimana Gloriose, Known as Gogo, Passes Away at 36

    EC Refutes Claims of Akena, Amongi Deletion

    EC Refutes Claims of Akena, Amongi Deletion

    Trending Tags

  • Climate Change
  • Business
  • Science and Technology
  • Sports and Entertainment
  • Business
  • Others
    • Education
    • Lifestyle
    • Religion
    • Opinions
  • News
    Nine Cleared for Amolatar LCV Chairperson Race as Campaigns Begin

    Nine Cleared for Amolatar LCV Chairperson Race as Campaigns Begin

    Rubirizi Grapples With Alarming Increase in Suicide Cases

    Three Die in Suspected Electrocution at Bushenyi Crusade

    “No More Tolerance”: Museveni Blasts Judges Over Bail for Criminals

    Museveni defends Karangwa on ethnicity

    NWSC Restores Normal Water Supply to Gulu After Completion of Works on Karuma-Gulu Main Transmission

    NWSC Restores Normal Water Supply to Gulu After Completion of Works on Karuma-Gulu Main Transmission

    Rwandan Gospel Artist Musabyimana Gloriose, Known as Gogo, Passes Away at 36

    Rwandan Gospel Artist Musabyimana Gloriose, Known as Gogo, Passes Away at 36

    EC Refutes Claims of Akena, Amongi Deletion

    EC Refutes Claims of Akena, Amongi Deletion

    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
0
VIEWS
Share on FacebookShare on X

READ ALSO

Nine Cleared for Amolatar LCV Chairperson Race as Campaigns Begin

Three Die in Suspected Electrocution at Bushenyi Crusade

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

Nine Cleared for Amolatar LCV Chairperson Race as Campaigns Begin
News

Nine Cleared for Amolatar LCV Chairperson Race as Campaigns Begin

September 6, 2025
Rubirizi Grapples With Alarming Increase in Suicide Cases
News

Three Die in Suspected Electrocution at Bushenyi Crusade

September 6, 2025
“No More Tolerance”: Museveni Blasts Judges Over Bail for Criminals
News

Museveni defends Karangwa on ethnicity

September 5, 2025
Bridging the Protection Gap in Uganda’s Green and Agricultural Economy
CLIMATE ACTION REPORTS

How African leaders can drive the real change at the Africa Climate Summit II

September 5, 2025
NWSC Restores Normal Water Supply to Gulu After Completion of Works on Karuma-Gulu Main Transmission
News

NWSC Restores Normal Water Supply to Gulu After Completion of Works on Karuma-Gulu Main Transmission

September 5, 2025
28 Suspected Ebola Cases, 15 Deaths Reported in Congo
Health

28 Suspected Ebola Cases, 15 Deaths Reported in Congo

September 5, 2025
Next Post

Controversial Magufuli dies aged 61

POPULAR NEWS

Minister Amongi, Akena Scrapped from EC Voters’ Register Oops

Minister Amongi, Akena Scrapped from EC Voters’ Register Oops

September 3, 2025
Catholic Priest Speaks Out Against Museveni and Son’s Leadership

Catholic Priest Speaks Out Against Museveni and Son’s Leadership

February 16, 2025

“Life Is Scum”: Kabale University Student Leaves Suicide Note, Takes Own Life

July 25, 2025

Former IGP Okoth Ogola Dies

February 14, 2025

CAF Warns Fans Against Obscene and Politically Charged Jerseys at Namboole

August 20, 2025

EDITOR'S PICK

Equity Bank Uganda Limited Delegation Visits Nation Media Group

July 3, 2025
Airtel appoints Joweria Nabakka as its new customer experience director

Airtel appoints Joweria Nabakka as its new customer experience director

January 24, 2024

Mbarara Hospital to Help Offload Heart Surgery Patients from Uganda Heart Institute

August 19, 2023

Dictator Museveni, Son Holding Uganda Captive

March 25, 2023
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

  • Nine Cleared for Amolatar LCV Chairperson Race as Campaigns Begin
  • Three Die in Suspected Electrocution at Bushenyi Crusade
  • Museveni defends Karangwa on ethnicity
  • How African leaders can drive the real change at the Africa Climate Summit II
September 2025
M T W T F S S
1234567
891011121314
15161718192021
22232425262728
2930  
« Aug    
  • 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