1. Due to the recent site upgrade, the iPadForums (iPF) App will no longer work. The new iPadForums.net website has been designed from the ground up to work perfectly from any mobile, tablet, or desktop computer using the built in internet browser. Create a shortcut to iPadForums.net on your home screen by following these steps: Create an icon for iPadForums.net

Numbers

Discussion in 'Forum Rules, Help and Info' started by Richard Webb, Sep 24, 2012.

  1. Richard Webb
    Offline

    Richard Webb iPF Novice

    Joined:
    Jul 6, 2012
    Messages:
    16
    Thanks Received:
    0
    Trophy Points:
    0
    Ratings:
    +0 / 0
    Anybody know how to fill in sequential dates in columns using numbers program I can do this on excel but this does seem to be available in numbers. But I could also be wrong. The help is not brilliant on Numbers

    Sent from my iPad using iPF
  2. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    15,982
    Thanks Received:
    1,843
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +1,987 / 1
    Yep. It's not hard, once you know what you are doing. Like Excel, Numbers has a Fill feature.

    Enter your first date in the beginning cell.
    Exit the cell editor.
    Tap the cell to select it and get the pop-up menu.
    Choose Fill.

    A yellow box with highlight the cell.

    Drag the edge of the box either vertically or horizontally to start filling.

    This defaults to single increment fills. If you want to fill, say by day of the weak, create the first two cells with the right increment. Select them both (by by dragging the dots when after selecting the first cell); Then select Fill from the pop-up menu and continue as before.

    Fill also works with numbers and text (with some limitations).


    Don't forget that you've got built in Help in Numbers. Tap the wrench icon and choose Help. The instructions for Fill (briefer but illustrated) are under the Enter data into a table cell chapter.
  3. Richard Webb
    Offline

    Richard Webb iPF Novice

    Joined:
    Jul 6, 2012
    Messages:
    16
    Thanks Received:
    0
    Trophy Points:
    0
    Ratings:
    +0 / 0
    Thanks I will give that a try I have already got to the yellow box but could not go any further, but will try now let you know thanks for quick reply

    Sent from my iPad using iPF
  4. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    15,982
    Thanks Received:
    1,843
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +1,987 / 1
    Good luck. The hardest part is dragging exactly the right number of cells. But you can always tweak the last few if you need to.
  5. Richard Webb
    Offline

    Richard Webb iPF Novice

    Joined:
    Jul 6, 2012
    Messages:
    16
    Thanks Received:
    0
    Trophy Points:
    0
    Ratings:
    +0 / 0
    Just tried it works great. Thanks for the help

    Sent from my iPad using iPF
  6. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    15,982
    Thanks Received:
    1,843
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +1,987 / 1
    No problem. Glad to help.
Similar Threads
  1. alkan
    Replies:
    4
    Views:
    3,399
  2. markskidmore
    Replies:
    4
    Views:
    1,085
  3. rmpresti
    Replies:
    3
    Views:
    473
  4. Richard Webb
    Replies:
    2
    Views:
    824
  5. Pauley
    Replies:
    9
    Views:
    689
Loading...

Share This Page

Search tags for this page

sequential numbering for ipad numbers