Is it possible to copy and paste a formula without changing the cell references?

Don't know if this works in Nubers but in Excel it's

Assuming A2-B2: to make the references permanent you'd enter $A$2-$B$2

I meant Numbers! and I tested it, now can confirm it works

Message was edited by: Csound1

I don't know of a command to do that, in Excel I would use a VBA script but I don't know whether Numbers supports VBA.

In Excel if you select a cell reference eg A2-B2 whatever part of it you have selected will toggle between absolute and relative using the F4 key, possibly Numbers has a formula you could use but I am an oldtimer, still using Excel.

dedwards96 wrote:

Just another quick question, is it possible to make a large number of cell references 'absolute'?

Individual cell references in formulas may have four distinct states: relative, absolute column, absolute row, or absolute column and row. These are set using the popup menu on the reference itself. Click on the reference in the formula and choose one of the four states from the popup menu.

Once set, you can fill the formula into the rest of a column or row using the Fill Handle (small circle at the lower right of a selected cell). Cell references in the new copies of the formula will remain absolute or adjst to their new position dependent on the setting for each reference. You can also copy and paste the cell (single click to select it, command-C to copy) with the same results.

You can also copy/paste without changing the formula's cell references if you select the formula (Drag across the formula in the entry bar, copy, press tab to deselect and reconfirm the formula in the original cell) rather than the cell. Pasted into a new cell, the formula will appear as if you typed it in exactly as it was in the original cell—neither absolute references nor relative references will have changed.

Regards,

Barry

There is a really simple way to achieve your goal.

Select the cell whose formula must be copied.

click in the formula bar

Select all

copy

Now, you may paste where you want.

You will get the exact replica of the original formula.

Yvan KOENIG (VALLAURIS, France) dimanche 12 juin 2011 20:57:55

iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.7

Please : Search for questions similar to your own before submitting them to the community

To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !

You're welcome

Well that's useful to know, thanks Barry