Control Data Input

Put data in a cell? Sure, just click in a cell and type—what else is there to know? You can learn about options for entering data, and the many different types of data that Numbers recognizes and can handle automatically, as described in Understand Automatic Data Formats, and how toUnderstand Automatic Data Formats when your cell runneth over.

And then there’s letting Numbers do more of the work for you: Speed Data Entry with Autocomplete and Speed Data Entry with Autofill. You can also do more than just a plain ol’ copy and paste: Explore Copy and Paste Options shows you how to copy and paste within and between tables, and leave a cell’s data behind if you want to copy only its formatting to paste in another cell. ...

Get Take Control of Numbers, 3rd Edition 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.