Subscribe to
Posts
Comments
NSLog(); Header Image

Numbers’ Lack of ‘Fill Down’

Posted August 20th, 2007 @ 04:30pm by Erik J. Barzeski

So, I fire up Numbers, Apple's spreadsheet addition to iWork's suite of productivity apps, and my productivity falls through the floor.

Where the hell is "Fill Down"? How can I copy a formula and paste it into a bunch of cells?

Sure, I can drag the little circle down. That works… but why isn't this a menu item ("Fill Down") or a capability of paste? Why does "paste" only paste the formula into one cell when I have 140 selected?

3 Comments »

3 Responses to "Numbers’ Lack of ‘Fill Down’"

  1. | Reply Michael
    Posted 21 Aug 2007 at 9:09am #

    I had the same problem: "Where is fill down?" But using the little circles seems like a reasonable alternative - once I finally found it.

  2. | Reply Amorya
    Posted 21 Aug 2007 at 10:58am #

    It is sort of smart though. If you've used the circle to fill down, and then you resize your table to make it bigger, it puts your formula in the newly created rows too.

  3. | Reply Bryan
    Posted 24 May 2011 at 9:24am #

    But I have 3000 cells... not going to hold the circle for 10 minutes.