background preloader


Facebook Twitter

NEW NEW NEW Google Sheets: Make Checkboxes. A new feature in Google Sheets spreadsheets is the ability to add a checkbox to a cell. Pretty much this is going to end up being the feature I use the most often! Who doesn’t need to check things off?! Click here to view my sample spreadsheet. Make a Spreadsheet Choose a Column You will need a column for your checklist. Highlight the Column Click on the column indicator for where you want the checkboxes. Data Validation Either right click on the column indicator or hover over the column indicator and look for the tiny triangle. A pop up will appear. Criteria The default criteria is “List from a range.”

And there you go! Sort Checked The checkboxes return a value of True if checked or False if unchecked. Insert Menu You can also use the Insert menu to create checkboxes for your highlighted range of cells. Copyright secured by Digiprove © 2018. Comptes Annuels.