Table of Contents
In this article, I’ll show you how to add checked boxes in Google Sheets to enhance your productivity and workflows.
Whether you use Google Sheets for data organization, project tracking, or to-do lists, adding checkboxes to your spreadsheets is a handy tool for improving data management.
And guess what? It’s much simpler than you might think!
So, without further ado, let’s get stuck in.
How To Add Check Boxes In Google Sheets?
If you’re looking to enhance your productivity and organization in Google Sheets, adding checkboxes is the perfect superpower!
Here’s how to get started:
- Login to Google Workspace.
- Open up the Google Sheets spreadsheet you want to add your checked boxes onto.
- Select all the cells where you want to insert checkboxes.
- Click ‘Insert’ on the top menu, then ‘Tick box’ from the drop-down menu.
- This will insert one square box into each cell you selected.
- Simply click on each square box to add a ‘tick.’
- If you want to remove the tick from the box, click on the square again.
And that is how easy it is to add check boxes to Google Sheets!
Read more: How To Merge Cells In Google Sheets.
How To Delete Check Boxes In Google Sheets?
Need to remove any checkboxes? No stress! This process involves just two steps:
- Select the checkboxes you want to remove.
- Click ‘Delete’.
Yep – that’s it! It truly is that simple to delete checkboxes in Google Sheets.
How To Add Custom Values To Check Boxes In Google Sheets?
If you want to tailor your checkboxes to show a particular value, follow the steps below:
- Open your Google Sheet.
- Select the cells to which you want to add checkboxes.
- Click ‘Data’ from the top menu, then ‘Data validation’ from the drop-down menu.
- Click ‘Add rule,’ then select ‘Tick box’ from the drop-down menu below ‘Criteria.’
- Select ‘Use custom cells.’
- Next to ‘Ticked,’ enter a value.
- Next to ‘Unticked,’ enter a value (optional).
- Select ‘Done’
You can add any custom value you like to your checkboxes! For example, the checked value could be ‘Yes,’ and the unchecked value could be ‘No.’
This means that when you type ‘Yes’ into the cell, Google Sheets automatically adds a tick!
Read more: Can You Mail Merge In Google Sheets?
How To Customize Check Boxes In Google Sheets?
Did you know you can easily customize the appearance of your check boxes by leveraging conditional formatting in Google Sheets? To do this:
- Select the cells containing the checkbox(es).
- Click ‘Format’ on the top menu and click ‘Conditional formatting’ from the drop-down menu.
- Under ‘Format cells if,’ select ‘Custom formula is’ from the drop-down menu.
- Type ‘=A1=TRUE’ (replace ‘A1’ with the relevant checkbox’s cell reference) in the ‘Value or formula’ field.
- Tailor the formatting for the checked state of the checkboxes as you please.
For example, you could change the cell’s background color or the checkbox color so it stands out.
- Hit ‘Done’ to implement the formatting changes.
You can also replicate the above steps to customize the unticked check box’s appearance by changing the formula to ‘=A1=FALSE’ instead.
My Google Sheets CRM Template (Sheetify CRM)
Okay, so as you can see, adding check boxes in Google Sheets is super easy and can help you organize simple business data, tasks, to-do lists, and more.
But what if you’re looking to take things to the next level?
Introducing….Sheetify CRM.
Sheetify CRM is my customizable, easy-to-use, all-in-one CRM template built entirely by Google Sheets.
We’ve created this fully functional business toolkit to help you manage various business areas on your favorite Google platform, Google Sheets.
The best part is that you don’t have to muck around with functions, formulas, and conditional formatting. Our expert team has done it all for you!
We’ve already added conditional formatting like drop-down menus and checkboxes into various areas of the CRM so you can easily:
- Change task and deal statuses.
- Ensure your invoices have been paid and sent.
- Manage customer ticket statuses.
- Send bulk emails to your clients and so much more!
You only have to input your business data and tick the relevant boxes. We take care of the rest.
Every piece of data entered is interconnected, meaning any modifications made in a particular section will automatically change in other relevant sheets.
Read more: Best Google Sheets CRM Template.
What Is Sheetify CRM?
If you’re looking for a total CRM toolkit to help you manage your contacts, sales, and tasks, automate inventory, capture leads, and send emails, listen up.
Sheetify CRM is an intuitive Google Workspace CRM explicitly built for free and paid Google users.
This Google CRM template is the whole package – simple yet functional and customizable!
Sheetify caters to small and micro-businesses wanting to organize and manage their customer-related data within one Google Sheet.
Some key features of Sheetify CRM include:
- Contact, lead, and sales management.
- Inventory, transaction, and purchase monitoring.
- Lifetime customer tracking.
- Invoice creation.
- Customer ticket/issue tracking.
- Email marketing.
- Google Forms and Google Task integration.
- Sales and customer calendar.
- Performance reporting dashboard.
So, how do you get your hands on this awesome Google CRM template? Simply install, download, and add the template to your Google Workspace account.
Sheetify CRM is available for just one low-cost payment of $67, which includes all current and future features and updates!
Talk about an ultimate lifetime CRM solution!
Check out my comprehensive video guide below to see how you can get started with Sheetify CRM
Stews Final Thoughts
That brings me to the end of this how to add check boxes in Google Sheets guide.
It’s safe to say that this simple yet effective method can significantly simplify data management tasks, enhance organization, and boost productivity!
By following the steps outlined in this guide, you can harness the power of checkboxes to streamline processes, track progress, and improve collaboration within spreadsheets.
Whether you add check boxes in Google Sheets yourself or leverage my Google Sheets CRM template, Sheetify CRM, there’s one thing I know for certain:
Adding check boxes in Google Sheets is essential to increase efficiency in your spreadsheet workflows!
Thanks so much for reading.
