Data Input

Put data in a cell? Sure, just click in a cell and type—what else is there to know? Well, there’s the many different Types of Data that Numbers recognizes, how to make sure it knows which you’re entering, and how Text Wrap in Cells works when your cell runneth over.

And then there’s letting Numbers do more of the work for you with Autocomplete and Autofill. You can also do more than just copy and paste data with Copy and Paste; you can leave the cells’ formatting behind if you want, for instance, or paste only the formatting in the new location.

There’s also Numbers’ very Special Data-input Formats that both speed data entry and ensure accuracy: Checkboxes, Star Ratings, Pop-up Menus, and Sliders and Steppers.

Data Entry Basics

Get Take Control of Numbers now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.