MacAlexNF

Q: Iwork, Numbers question on adding several rows and speed scrolling

Hi,

 

In Numbers (Ipad version), is there a way to add several row or columns at a time? Instead of doing the one at a time thing. Somehow to add 2 to X number of rows or columns in between.

 

Or scroll up or down faster in large worksheets? Some kind of speed scrolling. Carpal tunnel syndrome starting here in my index finger. Sos

 

 

If not please take note of this Apple Iwork people. I would greatly appreciate this in the next upgrade.

 

 

Thanks. cheers.

Posted on Apr 21, 2011 7:10 PM

Close

Q: Iwork, Numbers question on adding several rows and speed scrolling

  • All replies
  • Helpful answers

  • by jaxjason,Helpful

    jaxjason jaxjason Apr 21, 2011 7:22 PM in response to MacAlexNF
    Level 4 (3,729 points)
    iWork
    Apr 21, 2011 7:22 PM in response to MacAlexNF

    I am not sure about the one at a time thing, can you explain further. The formula fill functionality works pretty good. Please give us some more detail and we can try to help more.

     

    As for apple listening, that does not happen here.

    Please visit http://www.apple.com/feedback and let them know your suggestions.

     

    Jason

  • by MacAlexNF,

    MacAlexNF MacAlexNF Apr 22, 2011 7:22 AM in response to jaxjason
    Level 1 (0 points)
    Apr 22, 2011 7:22 AM in response to jaxjason

    Hi, jason,

     

    By the one at a time thing I meant that as far as I know if I want to add rows somwhere in between in the worksheet I have to tap the worksheets left margin to get the gray sliders, then tap again and get the "cut, copy, paste, delete, insert" tabs, than tap "insert", and I get one row. If I want to add a second row, I have to tap the gray slider again, than the tabs, and insert. If I need to add x number of rows in different parts in a worksheet this task becomes a pain...

     

    Many thanks, I will send feedback to apple.

     

    cheers

     

    Alex

  • by jaxjason,Helpful

    jaxjason jaxjason Apr 22, 2011 8:14 AM in response to MacAlexNF
    Level 4 (3,729 points)
    iWork
    Apr 22, 2011 8:14 AM in response to MacAlexNF

    now i got you, and yes one row at a time *in the middle of other rows of data* is one at a time.

     

    One alternative method that might work.

    • Add a column that has each row numbered. (dont use a formula, fill down straight numbers)
    • at the point you want to add fifty rows, change the next row down to the previous +2.
      • i.e. if you wanted to add 50 rows between 5 and 6, make row 6 #7 and fill down from there.
    • At the bottom of the table add your xx rows using the drag handle.
    • Number those rows all 6. (in our example)
    • sort by that column, you will now have xx rows inserted in the correct place between the old 5 ann 6.

     

    It sounds like alot, but it far less steps than adding 50 rows manually. Plus if you leave that column in, all you have to do later is change the row number where you want to add rows, fill down, add rows at bottom with the proper number. sort. done.

     

    Its a workaround, and I think that what you are asking for should be doable if we select multiple rows at once, Insert should still show up. I will go in later to http://www.apple.com/feedback and make the suggestion. If you do as well, it will logged multiple times. The more people that go in and log things, the more likely it is to get implemented.

     

    Thanks, and hope this helps out,

    Jason

  • by MacAlexNF,

    MacAlexNF MacAlexNF Apr 22, 2011 8:29 AM in response to jaxjason
    Level 1 (0 points)
    Apr 22, 2011 8:29 AM in response to jaxjason

    Hi, Jason,

     

    Many thanks for the workaround. I will go ahead and try it. And yes I will send them feedback also.

     

    I appreciate your help very much.

     

    cheers,

     

    Alex

  • by BobM2,

    BobM2 BobM2 Oct 1, 2015 7:27 PM in response to MacAlexNF
    Level 1 (0 points)
    Oct 1, 2015 7:27 PM in response to MacAlexNF

    To insert multiple blank rows, select any number of rows from a blank area of the spreadsheet. Touch the row bar at the left of the block of blank rows until it appears to lift off the page. Drag and drop the block of blank rows to the desired insertion point. Essentially, what you are doing is using the move function to move a group of blank rows to the insertion point. This also works for inserting multiple columns.