Take Control of Numbers, 3rd Edition

Use Special Data‑Input Options

Numbers has five special cell-formatting options that both speed data entry and limit the scope of the data that can be entered (which minimizes mistakes). As a bonus, some of these formats provide at-a-glance information—you don’t have to read numbers and compare them mentally, for example, when you create checkboxes, Use Star Ratings for one-click data entry, or Define Sliders and Steppers or Build Pop-Up Menus to control data input

Create Checkboxes

Checkboxes are easy to add to a table, and incredibly handy when all you need is to indicate whether a certain condition has been met or not: registered, passed exam, met quota. They let you enter information quickly, and “read” a row or column of data ...