Applexometa
Level 1 (43 points)
Photos for Mac

Q: iPad 2/Numbers How-To Add Row Below

I'm creating an invoice sheet that I'd like to add like I do in Numbers in OSX

In Numbers on OSX I just press the ALT-Down Arrow to create a row below the previous product line item.

 

I'm trying to figure out a way to accomplish this on the ipad 2 using iOS 5 and Numbers

 

 

For example, in the image attached, I want to add a productname2 below Product Name Here line.

 

 

 

/___sbsstatic___/migration-images/170/17095180-1.png

 

 

Thanks

iMac, Mac OS X (10.7.2), MacBook Pro | MacBook Air | iPad 2

Posted on Dec 25, 2011 7:14 PM

by jaxjason,Apple recommended
jaxjason jaxjason
Level 4 (3,729 points)
iWork
A:

If your bottom subtotal/tax/total rows are formatted as footer rows, its even easier than tapping the row header. Just tap the circle at the bottom of the rows list (bottom left side of the table). It will add a single row above subtotal (the highest footer row), Ready for you to enter your next invoice item at the bottom of the list.

Posted on May 2, 2016 1:59 PM

Close
Applexometa

Q: iPad 2/Numbers How-To Add Row Below

  • All replies
  • Helpful answers

  • by Jerrold Green1,

    Jerrold Green1 Jerrold Green1 Dec 25, 2011 6:37 PM in response to Applexometa
    Level 7 (29,991 points)
    Dec 25, 2011 6:37 PM in response to Applexometa

    Best to ask in the iOS iWork discussion area. Most of here in the OSX iWork area do not have iOS devices.

     

    Jerry

  • by bwfromspring hill,

    bwfromspring hill bwfromspring hill Dec 26, 2011 10:08 AM in response to Applexometa
    Level 4 (1,477 points)
    Dec 26, 2011 10:08 AM in response to Applexometa

    The easiest way is to use the iPad Numbers Form feature.

     

    At the top of the sheet find the "+" tab and tap it. Select new form and base it on the table that you use for the invoice.

     

    If your table is anything like the Invoice Template that came with Numbers, a Form will be created that allows line entry into your table and when you get to the bottom of the invoice list of products will creates a new row. (Use the "+" on the bottom of the form to make new items.

     

    The footer calculations should include the new row's data automatically.

     

    Good luck.

  • by MICHAEL SLONE,

    MICHAEL SLONE MICHAEL SLONE Jan 5, 2012 3:49 PM in response to Applexometa
    Level 1 (0 points)
    Jan 5, 2012 3:49 PM in response to Applexometa

    Adding rows is easy ... Just click on the far left bar which highlights the row and select insert.

     

    Adding cells is a different story!

  • by TaylorSMarks,

    TaylorSMarks TaylorSMarks Apr 29, 2016 7:39 PM in response to MICHAEL SLONE
    Level 1 (4 points)
    Apr 29, 2016 7:39 PM in response to MICHAEL SLONE

    Thanks! I was under the impression that inserting a row in the middle of a table was impossible in the iOS version of Numbers! I'd been syncing spreadsheets to iCloud, then adding new blank rows on my Mac, then filling them out on my iPhone as needed. It was an obnoxious process, to say the least.

  • by jaxjason,Apple recommended

    jaxjason jaxjason May 2, 2016 1:59 PM in response to Applexometa
    Level 4 (3,729 points)
    iWork
    May 2, 2016 1:59 PM in response to Applexometa

    If your bottom subtotal/tax/total rows are formatted as footer rows, its even easier than tapping the row header. Just tap the circle at the bottom of the rows list (bottom left side of the table). It will add a single row above subtotal (the highest footer row), Ready for you to enter your next invoice item at the bottom of the list.