Adding a checkbox , also known as a tickbox , is a useful way to organize your spreadsheets .
Whether you want to make managing a work project easier , or want to organise your own personal monthly budget , Google Sheets allows you to well add up or delete checkboxes to make your spreadsheets more user well-disposed .
lend a checkbox is improbably wanton to do and can really straighten up your spreadsheet . Keep take to learn how to append a checkbox in Google Sheets .
What you’ll need:
The short version:
Step 1.
Open Google Sheets
There are a few agency to open Google Sheets . If you have downloaded the Google Sheets app then but launch this . On the Google Chrome web browser app , you could either search for Google Sheets in the lookup panel or take the Google apps ikon at the top - right of the New tab key browser app page , as shown here . On all other web web browser , you could chit-chat https://sheets.google.com/ and sign in with your Google write up there .
Step 2.
Open the document you would like to edit
you’re able to either create a new Blank spreadsheet or choose one of your antecedently edited spreadsheets that will be list on this Sir Frederick Handley Page .
Step 3.
Select the cell or cells you’d like to add tick boxes to
you may either take an individual cell or you may highlight multiple cells . To spotlight multiple cells , hold up down the unexpended click push button , either on your mouse or trackpad , against all the hope cell .
Step 4.
Select Insert on the top menu panel
You ’ll find this selection listed just underneath the claim of your Spreadsheet .
Step 5.
On the Insert menu, select Tick box
By selecting this , you will like a shot sneak in a tick box into the cellular telephone . To delete it , plainly tap the jail cell surrounding the boxful and press the delete or backspace headstone on your keyboard .
Troubleshooting
Once you ’ve select the cells you want to add tick box to , tap the three dots ( More ) button in the top - right > Tap Data validation > In the list under Criteria , tap Tick loge .
You ca n’t currently add tick box on the iOS app so you ’ll have to either use an Android app or a web browser app . Once you ’ve add the check mark box in , you will be able to interact with it on the iOS app .
