Google Sheets - Hidden Treasures
View the videos below to uncover the Google Sheets hidden treasures... Adding Checkboxes Adding Dropdown Lists
Posts
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 .
Explore Google Explore
Have you explored the new EXPLORE feature in Google? Take 19 seconds to watch this video as I demonstrate two easy ways to access it - both in Sheets and Slides . Enjoy!