How do I "fill down" or "fill right" in Numbers 3.1?
How does one "fill down" or "fill right" to copy relative formulas in Numbers 3.1?
iMac, OS X Mavericks (10.9.1)
How does one "fill down" or "fill right" to copy relative formulas in Numbers 3.1?
iMac, OS X Mavericks (10.9.1)
It's just like in Version 2, except that the Fill Handle has moved to the center of the selection border instead of the corner. Mouse over the line to reveal the handle.
Jerry
It's just like in Version 2, except that the Fill Handle has moved to the center of the selection border instead of the corner. Mouse over the line to reveal the handle.
Jerry
Thanks Jerry!
I've tried to do what everyone who answered this post has suggested (finding the little yellow circle and drag gin it down), but what happens to me is that the value I have in the original cell grow by one each cell--for instance, if I have a 5.5 in the first cell, the next one will be 5.6, and then 5.7, etc. I want an easier way to paste the original figure to the next several without going command + V each time.
Thanks
Hi,
If you cmd-v the second cell and then select both the fill should woek the way you wish.
quinn
Thanks, so basically there's no real equivalent to Excel's Ctrl+D; it's more like in Numbers, a matter of copying and pasting. That will work, even though it's two steps rather than one.
Thanks for the help.
Its just like using Excels fill control handle in the bottom right hand corner of the current selections bold border.
Most people dont use the Ctrl-D shortcut. I typically use the double click trick instead of Ctrl-D, even faster.
Jason
How do I "fill down" or "fill right" in Numbers 3.1?