Skip navigation

Iwork, Numbers question on adding several rows and speed scrolling

1383 Views 4 Replies Latest reply: Apr 22, 2011 8:29 AM by MacAlexNF RSS
MacAlexNF Calculating status...
Currently Being Moderated
Apr 21, 2011 7:10 PM

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.

  • jaxjason Level 4 Level 4 (3,320 points)

    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

  • jaxjason Level 4 Level 4 (3,320 points)

    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

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.