• Latest
Learn How to Create Dropdown List in Google Sheets

Learn How to Create Dropdown List in Google Sheets

March 17, 2021

Ssemujju on Anti-West Stance: “When They’re Feeding You, They’ll Lecture You”

May 30, 2025
Ssemujju on Anti-West Stance: “When They’re Feeding You, They’ll Lecture You”

ANT Calls for Calm Amid existing Diplomatic Disputes in Uganda

May 29, 2025
VINAStech Advert
Police Search NUP Premises Over Alleged Illegal Military Training

NUP Invites Expressions of Interest from Members Seeking Party Positions

May 29, 2025
UPDF, RDF Strengthen Relations Through Historic Sports Engagements

UPDF, RDF Strengthen Relations Through Historic Sports Engagements

May 29, 2025

Makerere University Student Dies in Iganga Road Accident

May 28, 2025

Literature Giant Ngugi wa Thiongo Dies at 87

May 28, 2025
Parliament Must Lead Uganda’s Clean Energy Shift in FY2025/26 Budget

Why the government needs to champion clean energy technologies awareness

May 28, 2025
Driving climate action for a sustainable future

Oil, Displacement and Despair: The hidden mental health crisis facing marginalised women and girls

May 28, 2025

UPC Urges Reflection and Reform Ahead of Uganda Martyrs Day

May 28, 2025

Chaos Erupts at DP Headquarters Over Forgery on List of Delegates Ahead of Mbarara Conference

May 28, 2025

UEDCL Blames Power Outages on Rampant Vandalism and Illegal Connections

May 28, 2025

Mao Quietly Moves DP NEC Members to Gen. Saleh’s Gulu Residence Ahead of Key Delegates Conference

May 28, 2025
  • About Us
  • Internship
  • Contact Us
Friday, May 30, 2025
Parrots Media
No Result
View All Result
  • Login
  • News

    Ssemujju on Anti-West Stance: “When They’re Feeding You, They’ll Lecture You”

    Ssemujju on Anti-West Stance: “When They’re Feeding You, They’ll Lecture You”

    ANT Calls for Calm Amid existing Diplomatic Disputes in Uganda

    Police Search NUP Premises Over Alleged Illegal Military Training

    NUP Invites Expressions of Interest from Members Seeking Party Positions

    UPDF, RDF Strengthen Relations Through Historic Sports Engagements

    UPDF, RDF Strengthen Relations Through Historic Sports Engagements

    Parliament Must Lead Uganda’s Clean Energy Shift in FY2025/26 Budget

    Why the government needs to champion clean energy technologies awareness

    Chaos Erupts at DP Headquarters Over Forgery on List of Delegates Ahead of Mbarara Conference

    Trending Tags

  • Climate Change
  • Business
  • Science and Technology
  • Sports and Entertainment
  • Business
  • Others
    • Education
    • Lifestyle
    • Religion
    • Opinions
  • News

    Ssemujju on Anti-West Stance: “When They’re Feeding You, They’ll Lecture You”

    Ssemujju on Anti-West Stance: “When They’re Feeding You, They’ll Lecture You”

    ANT Calls for Calm Amid existing Diplomatic Disputes in Uganda

    Police Search NUP Premises Over Alleged Illegal Military Training

    NUP Invites Expressions of Interest from Members Seeking Party Positions

    UPDF, RDF Strengthen Relations Through Historic Sports Engagements

    UPDF, RDF Strengthen Relations Through Historic Sports Engagements

    Parliament Must Lead Uganda’s Clean Energy Shift in FY2025/26 Budget

    Why the government needs to champion clean energy technologies awareness

    Chaos Erupts at DP Headquarters Over Forgery on List of Delegates Ahead of Mbarara Conference

    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

Ssemujju on Anti-West Stance: “When They’re Feeding You, They’ll Lecture You”

ANT Calls for Calm Amid existing Diplomatic Disputes in Uganda

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.

ADVERTISEMENT
Tags: AfSHG

Related Posts

News

Ssemujju on Anti-West Stance: “When They’re Feeding You, They’ll Lecture You”

May 30, 2025
Ssemujju on Anti-West Stance: “When They’re Feeding You, They’ll Lecture You”
News

ANT Calls for Calm Amid existing Diplomatic Disputes in Uganda

May 29, 2025
Police Search NUP Premises Over Alleged Illegal Military Training
News

NUP Invites Expressions of Interest from Members Seeking Party Positions

May 29, 2025
UPDF, RDF Strengthen Relations Through Historic Sports Engagements
News

UPDF, RDF Strengthen Relations Through Historic Sports Engagements

May 29, 2025
Education

Makerere University Student Dies in Iganga Road Accident

May 28, 2025
Obituary

Literature Giant Ngugi wa Thiongo Dies at 87

May 28, 2025
Next Post

Controversial Magufuli dies aged 61

Leave a Reply Cancel reply

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

POPULAR NEWS

Catholic Priest Speaks Out Against Museveni and Son’s Leadership

Catholic Priest Speaks Out Against Museveni and Son’s Leadership

February 16, 2025

Former IGP Okoth Ogola Dies

February 14, 2025

A Love Beyond Distance: A review of Leonard Kamugisha Akida’s poetic tribute on valentine’s day

February 14, 2025

Besigye Sends Easter Message from Luzira Prison as Archbishop Kazimba Urges for Release of Political Prisoners

April 18, 2025
Brutality at KIU: Students Assaulted by Officials at Examination Hall

KIU Loses Bid to Block Payment of Shillings 46.8 Billion to Housing Finance Bank

March 12, 2025

EDITOR'S PICK

Two arrested for vandalizing NWSC equipments in Rukungiri District

January 14, 2022
11 arrested at Ewa Nico bar with fake gun

11 arrested at Ewa Nico bar with fake gun

November 8, 2022

Planned Protest Against Museveni’s Visit to Ankole End in Disarray

February 17, 2025

Fire guts Masaka SS

October 10, 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

  • Ssemujju on Anti-West Stance: “When They’re Feeding You, They’ll Lecture You”
  • ANT Calls for Calm Amid existing Diplomatic Disputes in Uganda
  • NUP Invites Expressions of Interest from Members Seeking Party Positions
  • UPDF, RDF Strengthen Relations Through Historic Sports Engagements
May 2025
M T W T F S S
 1234
567891011
12131415161718
19202122232425
262728293031  
« Apr    
  • 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