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?
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.
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.
Posted 24 May 2011 at 9:24am #
But I have 3000 cells... not going to hold the circle for 10 minutes.