Apple Event: May 7th at 7 am PT

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Copy and Paste Formula from One Cell to Multiple (How?)

I am aware of the "autofill" function by dragging the bottom-right corner of a cell containing a formula.

However, I cannot possibly do this if I want to copy the formula and paste it into 10,000 cells.

If I specify a range of cells to paste the copied formula - only the first cell gets it. I have seen this problem in previous iWork for a long time but am surprised Apple has not improved it (or made it obvious enough for me to get it at first sight).

Thanks!

MacBook Pro, Mac OS X (10.4.10)

Posted on Aug 8, 2007 11:18 AM

Reply
21 replies

Jan 24, 2008 9:04 PM in response to Gulzt

The original post's author is well aware of this. I do agree with him that it is pathetic that you have to be innovative in order to implement such a basic spreadsheet feature, into a new program which is in its infancy, even though that feature has been employed by the grandfathers of spreadsheets. I gathers too that his issue was more concerned with copying a formula from a cell in 1 column, to multiple cells in annother column graphically, as you should be able to, and can in competing programs. While there are workarounds, dont you agree that it is lunacy that there has to be?

Jan 25, 2008 12:58 PM in response to Schwern

Hello

It's really funny to read this kind of comments.

It appears that XL users assume that the syntax used in XL is definitely incized in marble.

I apologize, Apple is perfectly free to adopt different syntax.

I'm satisfied by the choosen ones and so I uses Numbers.

If you aren't satisfied, why did you buy Numbers which you where allowed to test for free during 30 days?

I used AppleWorks for years and was acustomed to type cmd + d to fill down a selected range of cells.
Numbers uses an other way.
After some months of use, I'm really unable to say if one is better than the other.
And of course it's the same for many other functions.
For the ones which I really miss or dislike, I sent a report to Apple.

I just wonder why there is not a link in Numbers to ask them to get rid of this kind of threads 😉

Yes, I know the [Report this post] button, but it doesn't report to the Numbers's team 😉

Yvan KOENIG (from FRANCE vendredi 25 janvier 2008 21:58:15)

Mar 3, 2008 6:37 PM in response to Charles Lin

I hate to say this, not being an Excel fan, but the way Numbers handles copy/paste of functions totally flies in the face of any reasonable spreadsheet app I've ever used:

- excel 😟
- gnumeric
- open office
- a whole range of online spreadsheet applications.

Yes, apple is doing it different. The program LOOKS beautiful. But if I can't COMPUTE values easily - I'm moving on.

Yuck.

Copy and Paste Formula from One Cell to Multiple (How?)

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.