Pages

Tuesday, May 8, 2018

Checkboxes in Google Sheets


Google Sheets has recently added the checkbox option. Simply click INSERT > CHECKBOX in the SHEETS app:

An application of this tool for educators is a simple checklist as shown below:
Google SHEETS gives the value of FALSE to the unchecked cells and the value of TRUE to the checked cells.

In order to sort the data with the checkboxes grouped all together, select the range:

Then, select DATA > SORT RANGE.  Select whether or not the data has a header row, select the preferred column in the SORT BY section, and select either A-Z to place the checked checkboxes at the bottom of the column or Z-A to place the checked checkboxes at the top of the column.


Learn more about the new checkboxes feature here.


No comments:

Post a Comment