Ipad Numbers

Discussion in 'iPad FAQ' started by Tfladen, Mar 12, 2011.

  1. Tfladen
    Offline

    Tfladen iPF Noob

    Joined:
    Mar 12, 2011
    Messages:
    1
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Canton
    Ratings:
    +0 / 0
    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.

    Todd Fladen
  2. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,564
    Thanks Received:
    2,081
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,428 / 1
    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.
  3. kc2ped
    Offline

    kc2ped iPad Fan

    Joined:
    Sep 20, 2010
    Messages:
    134
    Thanks Received:
    5
    Trophy Points:
    0
    Location:
    New York City
    Ratings:
    +5 / 0
    I started reading The Missing Manual for iWorks09
    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.

Share This Page

Search tags for this page
apple numbers faq
,
apple numbers for ipad filling in number sequence not working
,

apple numbers manual

,
consecutive numbers in cells ipad numbers
,
enter a range manually ipad numbers
,
forum numbers ipad
,
how to have consecutive numbers in numbers for ipad
,
ipad numbers
,
ipad numbers copy cell
,

ipad numbers tutorial

,
manual for apple numbers app tutorial
,

numbers app for ipad manual

,
numbers app sequential numbers ipad
,

numbers app tutorial

,
numbers for ipad 2
,

numbers for ipad tutorial

,
numbers for ipad version 2 tutorial
,
numbers ipad app manual
,

numbers tutorial for ipad

,

numbers tutorial ipad 2