paste without changing formula?

  • Thread starter Thread starter Anne Heddal
  • Start date Start date
Hi Anne
if you use absolute cell references in your formula the formula will
not change. e.g.
=$A$1+1
won't change if copied
though
=A1+1 will change
Frank
 
You can copy from the formula bar, then paste to any number of cells (one at
a time) without changing the references.

Select the entire formula in the formula bar (everything looks black), then
right click in the selection and choose Copy.
*Now hit <Enter>*

You can then right click in any number of cells (one at a time), and simply
choose Paste.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Is this possible in Excel?
 
If it's more than one (or two) cells, you can change the formulas to strings.

select the range
edit|replace
=
with
zzzzz=

then copy|paste

and remember to change the zzzzz= back to = in both spots!
 
Back
Top