Sign In


Join the 5 Minute Guide community to share your own tutorials and participate in forum conversations!



How to Mimic Data Validation in Apple Numbers


If your an Excel user switching to Numbers from Apple’s iWork suite you’re likely to find yourself looking for data-validation options, but you won’t find them! At least not as such.

Using the inspector you can change the cell type to a pop-up list and add options to allow for your end user (or yourself) to select pre-defined options from the list

This video was made using Screenflow by Telestream (for Mac)

Tutor Bio

Alternative Text

In real life Mike is a husband and father of 2. He also develops websites (like this one) and makes overwhelming amounts of data understandable using Excel, Numbers, Access, etc.