Fill down in numbers

Discussion in 'iWork Forum' started by tony873004, Jan 23, 2013.

  1. tony873004

    tony873004
    Expand Collapse
    iPF Noob

    Joined:
    Jan 3, 2013
    Messages:
    4
    Thanks Received:
    0
    Hi. I imported data into numbers. The first column contains time and the second contains distance in meters. I inserted a new column in between them. I would like it to contain distance in centimeters. So I type =c2*100. Now I want to fill down so every row has this formula. I found I can drag the gold box to the bottom of the screen. But the bottom of the screen is a long way away. There is lots of data and I don't want it to take an hour. Is there a way I can auto fill the entire column? In Excel you just highlight the cell you want to fill down with and double click the little black box on the cells bottom right corner.

    Thanks!
     
  2. dougrogers

    dougrogers
    Expand Collapse
    iPad Fan

    Joined:
    Jan 29, 2011
    Messages:
    152
    Thanks Received:
    10
    The last cell you drag to remembers the formula. Just drag and fill again from there. Won't that work?
     
  3. tony873004

    tony873004
    Expand Collapse
    iPF Noob

    Joined:
    Jan 3, 2013
    Messages:
    4
    Thanks Received:
    0
    Yes, dragging works. But I can only drag to the last cell visible on the screen. My spreadsheet has over 1000 rows of data. So drag, scroll, highlight, drag, scroll, repeat 50 times... takes forever. Isn't there a simple way to make it go the last row for you automatically, like they have in Excel? It would be a HUGE time-saver.
     
  4. twerppoet

    twerppoet
    Expand Collapse
    iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    19,822
    Thanks Received:
    4,881
    If you approach the edge of the screen slowly, at one point it will start scrolling down and continue the Fill. Stop your finger there and wait for it to get to the bottom of the table. The scrolling is easy to miss. Just keep an eye on movement, whether it looks like scrolling kind movement or not.

    Might take a couple tries, but even if it doesn't work every time, I'm sure you can reduce the number of time you need to go through the motions.
     
  5. tony873004

    tony873004
    Expand Collapse
    iPF Noob

    Joined:
    Jan 3, 2013
    Messages:
    4
    Thanks Received:
    0
    Thanks for the reply!
    I discovered that method. The problem is that it takes too long.
    I teach high school Physics, and we take data from sensors, such a force sensors. These sensors can feed you thousands of rounds of data. Keeping your finger on the bottom of the screen while it scrolls at a maximum rate of about 4 rows per second can still take upwards of 20-30 minutes. I can't have half the lab period dedicated to holding your finger at the bottom of the iPad screen. Excel simply lets you double-click the bottom right corner of the highlighted box, and it fills down to the bottom for you, instantly. I was hoping Numbers had a similar feature, since my school heavily encourages using the iPad, which each student is required to own. But if Numbers doesn't have this basic feature, I'm going to have to find a plan B :( Thanks again for your reply!
     
  6. dougrogers

    dougrogers
    Expand Collapse
    iPad Fan

    Joined:
    Jan 29, 2011
    Messages:
    152
    Thanks Received:
    10
    Are you saying you're limited, bound, to inputting thousands of rows of data manually?
     
  7. twerppoet

    twerppoet
    Expand Collapse
    iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    19,822
    Thanks Received:
    4,881
    That's too bad. Numbers is a pretty good personal and even small business spreadsheet, but it's not the number cruncher to handle super sized tables; especially the kind that science experiments are likely produce. The hardware can even be a bit slow for this. My iPad 3 can get bogged down scrolling super sized tables. I imagine the iPad 4th gen is better.
     
    #7 twerppoet, Feb 2, 2013
    Last edited: Feb 2, 2013
  8. twerppoet

    twerppoet
    Expand Collapse
    iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    19,822
    Thanks Received:
    4,881
    It's not Excel. It's not even the OS X version. If you need to enter and track that kind of information you need to get a tool designed to do the job. Numbers on the iPad is pretty good as a personal or even small business spreadsheet. It was never meant to take the place of corporate or science apps.

    There are iPad solutions for this kind of thing out there, but they generally involve a central database and internet connectivity. And more money, of course. FileMaker Pro, for instance.
     
    #8 twerppoet, Feb 2, 2013
    Last edited: Feb 2, 2013
  9. dougrogers

    dougrogers
    Expand Collapse
    iPad Fan

    Joined:
    Jan 29, 2011
    Messages:
    152
    Thanks Received:
    10
    You're suggesting what I was approaching. Numbers, obviously, isn't the proper tool for the job. I thought there might be some other software solution, app, or input device. Maybe a laptop running Numbers? Or Excel? Obviously some other database, not a spreadsheet. Some solution capable of taking measurement data directly from some input device. Money of course. That's the answer.
     
  10. twerppoet

    twerppoet
    Expand Collapse
    iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    19,822
    Thanks Received:
    4,881
    The only way I can think of to avoid adding data to Numbers manually, is to import it. You can import .csv files. Actually, this works well for science applications. Most science instruments capture data as a text file with some kind of delimiter; coma being the most common (pun sort of intended).

    So it's not impossible to enter large amounts of data into Numbers, as long as you are willing to import it as a new spreadsheet, or copy&paste if from a comma delimited text file. The table will expand to hold the data. That still does not address the iPad being underpowered for huge data sets, but it's hard to tell how much impact a simple calculation will have without trying it.

    Which gives me an idea!

    Off to test, and if it works, post to the OP.
     

Share This Page



Search tags for this page

apple number drag formula down

,
apple numbers copy down
,
apple numbers fill down
,

excel for ipad fill down

,
excel in ipad drag down formula
,
how to fill right in ios numbers
,
iworks auto fill data
,
mac numbers fill down
,
numbers fill down
,
numbers ios filldown