This is a discussion on Ipad Numbers within the iPad FAQ forums, part of the Apple iPad Discussions category; 1. Other than "Beginning with numbers" on iPad app, is there a manual.
2. If I create a cell formatted for time with day and ...
1. Other than "Beginning with numbers" on iPad app, is there a manual.
2. If I create a cell formatted for time with day and date, can I drag this cell somehow or copy is value such that the next 30 cells either horizontally or vertically would be consecutively dated without having manually input such.
03-12-2011 11:27 PM
I've got iPad iWorks: The Unofficial Handbook. I don't care for it much. I suppose it is more complete than the the included tutorial, but it never seems to address the questions I come up with.
To do cell fills.
Tap to select the cell you want to start filling from. Wait a second, and tap it again. You'll get a menu. One of the items is Fill. Select it and you will get a yellow box with handles to drag either vertically or horizontally. Drag to fill cells with consecutive number, dates, times, etc.
If you drag text, it just duplicates the text.
If you want to set fill interval greater than 1, then create two cells with the gap between them. say cell one is 1, and two is 5. Then tap the cell to select, drag the handles to select both cells. Then do the menu, fill, drag thing to fill more cells.
Results sould be something like 1, 5, 10, 15, 20 etc. This should work with dates and times as well.
You may have to experiment to get the exact effect you want.
Note: If you tap twice too quickly you'll get the cell editor. Once you get used to this, it is actually kind of handy.
I started reading The Missing Manual for iWorks09
Originally Posted by Tfladen
The Numbers section is very informative but not very exciting so I kept falling asleep and had to return the book to the library before I got into the really useful stuff
For filling ranges I usually manually enter the first three values in the series to make sure Numbers understands my progression. Then is is simple tap and drag like twerppoet described. I haven't found Numbers to scroll when my finger reaches the bottom of the screen, or maybe I am just to impatient, so I have to drag the screen up and start another fill operation if the range I am filling is more than a screen high. This can be minimized a bit by pinching the table down to it's smallest size so more rows/columns fit on a screen.
A seed hidden in the heart of an apple is an orchard invisible.
Typo assist by iPad
By 7x7fan in forum iWork Forum
Last Post: 03-25-2012, 07:13 AM
By Zera in forum iWork Forum
Last Post: 09-02-2011, 08:49 PM
By paulyeo11 in forum iPad General Discussions
Last Post: 10-16-2010, 06:31 PM
By ginopiazza49 in forum iPad Apps
Last Post: 09-08-2010, 10:57 AM
By iDan in forum iWork Forum
Last Post: 05-11-2010, 09:16 PM
Search tags for this page
apple numbers manual
ipad numbers manual
ipad numbers tutorial
numbers app for ipad manual
numbers app tutorial
numbers for ipad tutorial
numbers tutorial for ipad
numbers tutorial ipad 2
Click on a term to search for related topics.