O'Reilly logo

Take Control of Numbers by Sharon Zardetto

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required