With the option to insert drop-down lists, validate data, and much more, Google Sheets is a great free alternative to Microsoft Excel. Use the “Reject input” option to lock down any cells you want to keep intact. Preventing other people from messing up with your scripts or formulas.Select “Use custom cell values” and type “yes, “no”, or whatever you’d like.Select Data Validation in the Data menu.When you add checkboxes to a drop-down list, you can also assign them values, like “yes” or “no”. In data validation, select the “dates” option, set conditional formatting as explained above, and set it up so that all items that include a certain date get grayed out automatically. In addition to adding drop-down lists to your sheets, you can use Data Validation for other purposes too. What Else You Can Do with Data Validation
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |