Sheets is a completely free alternative to the Microsoft Excel proposal; Additionally, we can use it from our browser without having to download anything, from anywhere and from any device. It's a powerful tool, although perhaps not as powerful as Excel. However, it is possible to create a checklist in Google Sheets , which is very useful for organizing and analyzing data..
With Google Sheets we can use segmentation, adjust text, change the currency, protect files with a password and it has hundreds of functions that have nothing to envy to Microsoft's office suite. One of these functions is the possibility of adding a checklist, ideal to apply in different cases.
Create checklist in Google Sheets
The first thing we will have to do is open a spreadsheet in Google Sheets from a new browser. We will prepare the spreadsheet with the data that will allow us to create a list. Next, we'll need to select the column and rows to the right of the list where we want the checkboxes to appear..
After selecting the column and rows, we will have to click on "Insert" in the toolbar at the top, from here we will have to choose Checkbox.
That would be all we would have to do. We can immediately see that the checkboxes will appear where we have made the selection..
Now we will simply have to click on the checkboxes to be able to check or uncheck them.
In case we want other users to be able to check the checkboxes , we'll need to make sure to update the sharing settings to allow them full editing access to the spreadsheet.
While this checklist is pretty basic, we're glad to see Google keep working to improve this cool and useful tool, especially since it's completely free and accessible from any device.
As you can see, it is extremely easy to add a checklist in Google Sheets. Likewise, remember that if you have any kind of doubt with this guide, you can leave it in the comment box that you will find a little below and we will be happy to help you in everything you need.