Check out the new Checkbox in Zoho Sheet
Checkbox,
the simple GUI widget that lets you choose between two mutually
exclusive options i.e Yes or No, is now in Zoho Sheet. Having made
it across the web, Checkbox is familiar but is still elusive to most
spreadsheet software. Special developer ribbons, macros and all
other complexities to add a checkbox to a spreadsheet? Not in Zoho Sheet.
How to add Checkbox to
Zoho Sheet?
Adding a Checkbox in Zoho Sheet is
simple. Select a cell/range and choose "Checkbox" in
"Input Controls" under the Format menu. Spreadsheet users
who have visited different forums to learn a workaround for
inserting a checkbox in other spreadsheet software can appreciate
the ease with which they can do it in Zoho Sheet.
Mouse
friendly, Keyboard friendly and User friendly
Check
or uncheck a Checkbox with a single click of the mouse. You
can do the same with a keyboard in different ways. Use Y/N or
T/F or 1/0 or the spacebar to check/uncheck a
Checkbox.
Checkbox
in a spreadsheet can be useful. Here's
why:
When you click a Checkbox, the
information can be captured and used, allowing different
functions to be built around it. This flexibility makes it a
useful feature that can be employed for various functions,
based on True/False parameters.
For example, Checkbox
feature comes in handy when you need to plan a
family trip. Create a checklist and share it with
the rest of your family. Add rules to your checklist
using Conditional formatting that each item gets
struck off the list when someone checks it. You can even
see who checked/unchecked the Checkbox under Audit Trail. So
collaborate with your family members to make sure you have
everything you need for your tour.
Note: Get hands-on experience of the feature here.
Checkbox is the first of Input
Controls. So, keep watching this space, we have more Input
controls to follow.