HalfofTheHalfofThe
  • Home
  • Technology
    • Reviews
    • Amazon
    • Apple
    • Cars
    • Facebook
    • Google
    • Mobile
    • Samsung
    • Tesla
    • Twitter
  • News
    • Sports
    • Amazon
    • Apple
    • Business
    • Cars
    • Entertainment
    • Facebook
    • Mobile
    • Samsung
    • Science
    • Tesla
    • Twitter
  • How To
    • Amazon
    • Apple
    • Cars
    • Facebook
    • Games
    • Google
    • Mobile
    • Samsung
    • Science
    • Tesla
    • Twitter
  • Business
  • Entertainment
  • Health
    • Pets
    • What
    • Why
  • Lifehacks
    • Explain
    • SmartHome
    • SocialMedia
  • More
    • Amazon
    • Apple
    • Cars
    • Facebook
    • Google
    • Mobile
    • Netflix
    • Twitter
    • Samsung
    • Tesla
Search
Technology
  • How To
  • Explain
  • Mobile
  • Lifehacks
  • News
  • Reviews
  • SmartHome
  • Technology
Information
  • About Us
  • Contact Us
  • Cookie Policy
  • Privacy Policy
  • Terms and Conditions
All content
  • Home
  • Technology
    • Reviews
    • Amazon
    • Apple
    • Cars
    • Facebook
    • Google
    • Mobile
    • Samsung
    • Tesla
    • Twitter
  • News
    • Sports
    • Amazon
    • Apple
    • Business
    • Cars
    • Entertainment
    • Facebook
    • Mobile
    • Samsung
    • Science
    • Tesla
    • Twitter
  • How To
    • Amazon
    • Apple
    • Cars
    • Facebook
    • Games
    • Google
    • Mobile
    • Samsung
    • Science
    • Tesla
    • Twitter
  • Business
  • Entertainment
  • Health
    • Pets
    • What
    • Why
  • Lifehacks
    • Explain
    • SmartHome
    • SocialMedia
  • More
    • Amazon
    • Apple
    • Cars
    • Facebook
    • Google
    • Mobile
    • Netflix
    • Twitter
    • Samsung
    • Tesla
  • About Us
  • Contact Us
  • Cookie Policy
  • Privacy Policy
  • Terms and Conditions
2022. All Rights Reserved by Halfofthe. “As an Amazon Associate we earn from qualifying purchases.”
Notification Show More
Latest News
What We Know So Far About Season Two of The Last Of Us
What We Know So Far About Season 02 of The Last Of Us
Entertainment
As a small company Why we don't want to use Google apps or services
As a small company Why we don’t want to use Google apps or services
Google
Breaking Down the Samsung Galaxy S23 Price Increase in Europe and Australia
Breaking Down the Samsung Galaxy S23 Price Increase in Europe and Australia
Samsung
Samsung's Galaxy S23 Ultra May Get Selfie Camera Upgrades
Samsung’s Galaxy S23 Ultra May Get Selfie Camera Upgrades
News Samsung
WhatsApp is Improving Image Quality with New Feature
WhatsApp is Improving Image Quality with New Feature
News
Aa
HalfofTheHalfofThe
Aa
  • How To
  • Explain
  • Mobile
  • Lifehacks
  • News
  • Reviews
  • SmartHome
  • Technology
Search
  • Home
  • Technology
    • Reviews
    • Amazon
    • Apple
    • Cars
    • Facebook
    • Google
    • Mobile
    • Samsung
    • Tesla
    • Twitter
  • News
    • Sports
    • Amazon
    • Apple
    • Business
    • Cars
    • Entertainment
    • Facebook
    • Mobile
    • Samsung
    • Science
    • Tesla
    • Twitter
  • How To
    • Amazon
    • Apple
    • Cars
    • Facebook
    • Games
    • Google
    • Mobile
    • Samsung
    • Science
    • Tesla
    • Twitter
  • Business
  • Entertainment
  • Health
    • Pets
    • What
    • Why
  • Lifehacks
    • Explain
    • SmartHome
    • SocialMedia
  • More
    • Amazon
    • Apple
    • Cars
    • Facebook
    • Google
    • Mobile
    • Netflix
    • Twitter
    • Samsung
    • Tesla
Follow US
  • About Us
  • Contact Us
  • Cookie Policy
  • Privacy Policy
  • Terms and Conditions
2022. All Rights Reserved by Halfofthe. “As an Amazon Associate we earn from qualifying purchases.”
HalfofThe > Blog > How To > How to Add a Checkbox in Google Sheets? Easy Guide
How To

How to Add a Checkbox in Google Sheets? Easy Guide

Bippin
Last updated: 2022/06/14 at 9:21 AM
By Bippin Published October 30, 2021
Share
3 Min Read
How to Add a Checkbox in Google Sheets? Easy Guide
How to Add a Checkbox in Google Sheets? Easy Guide
How to Add a Checkbox in Google Sheets? Easy Guide

Checkboxes come in handy for all types of situations, yes, even for data you add to a spreadsheet. In Google Sheets, you have the ability to add checkboxes for things like project tasks, answers to questions. OR. Selecting product attributes.

The thing about using a checkbox in Google Sheets is that you can also get to use data validation to assign custom values. In this article, we will show you how to insert a checkbox in Google Sheets.

How can you insert a Checkbox in Google Sheets?

  • Go to Google Sheets, sign in, then open the sheet you want. Select the cell where you want to place the checkbox. Click on Insert > Checkbox.
  • And that’s it: there will be a checkbox in the cell you selected, and it is ready to be checked.
  • You can use the fill handle to drag the checkboxes through adjacent cells, after which you may utilize the arrow keys with your mouse.
  • To remove a checkbox, select the cell, then press Delete on your keyboard.

How can you Add Custom Values to a Checkbox?

  • You can assign values to your checkbox if it’s checked/unchecked. Right-click the cell containing the checkbox, then click on “Data Validation.”
  • After the window opens, click on “Checkbox” in the Criteria drop-down.
  • Check the box of “Use Custom Cell Values.” Then enter the values for Checked/Unchecked. Click on “Save.”
  • If you want to use the values in your sheet, for example, the conditional formatting mentioned earlier, you will have values to work with for your checked/unchecked box.

How can you Remove Custom Values from a Checkbox?

  • Right-click the cell containing the checkbox, then click on “Data Validation”
  • Uncheck the box to Use Custom Cell Values, then click on “Save.” This allows you to keep your checkbox while removing the assigned values.

If you liked this article (or if it helped at all), leave a comment below or share it with friends, so they can also know How to Add a Checkbox in Google Sheets?

You Might Also Like

As a small company Why we don’t want to use Google apps or services

How to Reset Android Phone when Locked?

How to Share Location on Android?

How to Transfer Data from Android to Android?

How to Retrieve Deleted Text Messages on Android?

TAGGED: google sheet, google sheet tips, google sheets, google sheets sign in
Share this Article
Facebook Twitter Pinterest Whatsapp Whatsapp Reddit Telegram Email Copy Link Print
Avatar photo
By Bippin
Aah, I see you’re here now, looks like I finally managed to capture your attention. If you’ve come all the way here then why don’t you follow my social accounts, so that you can be on this journey with me? Say what?
Previous Article How to Install Extensions From Outside the Chrome Web Store? How to Install Extensions From Outside the Chrome Web Store?
Next Article How to transfer ebooks to Kindle via Calibre? Easy guide How to transfer ebooks to Kindle via Calibre? Easy guide
Leave a comment Leave a comment

Leave a Reply Cancel reply

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

Trending

Learn how to use the Microsoft word document
Learn how to use the Microsoft word document
Explain Microsoft
A few details regarding the upcoming Google Pixel 7 as well as the Pixel 7 Pro
A few details regarding the upcoming Google Pixel 7 as well as the Pixel 7 Pro 
Google
Apple M1 VS M2 Comparison - Features and Specs
Apple M1 VS M2 Comparison – Features and Specs
Apple Mac
How to Electronically Sign PDF Documents Without Printing and Scanning Them? Easy guide
Life How To
What Is r/Place? How to use it on Reddit? Everything Explained about rPlace
What Is r/Place? How to use it on Reddit? Everything Explained about rPlace
Lifehacks How To SocialMedia
How to View Blurred Text on Websites?
How to View Blurred Text on Websites?
How To

People Also Ask For

As a small company Why we don't want to use Google apps or services
Google

As a small company Why we don’t want to use Google apps or services

HalfofThe HalfofThe January 25, 2023
How to Reset Android Phone when Locked?
Android

How to Reset Android Phone when Locked?

Bippin Bippin January 22, 2023
How to Share Location on Android?
Android

How to Share Location on Android?

Bippin Bippin January 22, 2023
How to Transfer Data from Android to Android?
How To

How to Transfer Data from Android to Android?

Bippin Bippin January 19, 2023
How to Retrieve Deleted Text Messages on Android?
How To

How to Retrieve Deleted Text Messages on Android?

Bippin Bippin January 19, 2023
How to Facetime Android?
How To

How to Facetime Android?

Bippin Bippin January 18, 2023
How to Empty Trash on Android?
Android

How to Empty Trash on Android?

Bippin Bippin January 16, 2023
How to SSH on Windows?
How To

How to SSH on Windows?

Bippin Bippin January 14, 2023
How to Upgrade to Windows 10?
How To

How to Upgrade to Windows 10?

Bippin Bippin January 14, 2023
How to Install Windows 11?
How To

How to Install Windows 11?

Bippin Bippin January 13, 2023
How to Update to Windows 11?
How To

How to Update to Windows 11?

Bippin Bippin January 13, 2023
How to Install Windows?
How To

How to Install Windows?

Bippin Bippin January 11, 2023
Show More
HalfofTheHalfofThe
Follow US

2023. All Rights Reserved by Halfofthe. “As an Amazon Associate we earn from qualifying purchases.”

  • About Us
  • Contact Us
  • Cookie Policy
  • Privacy Policy
  • Terms and Conditions

Removed from reading list

Undo
Welcome Back!

Sign in to your account

Lost your password?