A checkbox is a small widget that allows users to make binary choices. The checkbox will display as ☑ when you answer "yes" while the checkbox will display as ☐ when you answer "no". The checkbox will make your work looks professional and it is very useful when you collect people's opinions. Google Sheets make the checkboxes much easier comparing Microsoft Excel. Please see below for details:
Step 1: Click any cell in the Sheet you want to insert a checkbox, e.g., Cell A1;
Step 2: Click the "Insert" tab from the ribbon;
Step 3: At the bottom of the drop-down list, click the "Checkbox";
Step 4: You will see a checkbox now in the cell A1;
Step 5: If you want to have more checkboxes, you can copy and paste as many as you want;
One advantage of the checkboxes with Google Sheets is that you can treat the checkboxes as the text in the cell and format them in the same way.
Step 6: To change the color of the checkboxes, select the checkboxes and click the "Text color" in the ribbon, then click the color you want;
Step 7: To change the alignment within the cell, select the checkboxes and click "Horizontal align" or "Vertical align" to adjust to the proper position;
Step 8: In case you want to delete the checkboxes, you can delete the whole column if you want to delete all of them, or select the checkboxes and press the "Delete" key from the keyboard;
Alternatively, you can select the checkboxes and click the "Edit" tab from the ribbon;
Step 9: Click "Remove checkboxes" at the bottom of the drop-down list.
