Copying Formulas

M

Mac

I'm trying to copy a formula from 1 spreadsheet to another. The formula
always changes to show the filename of the previous spreadsheet.

How do I copy/paste a formula "as is" without the filename being attached?
 
D

Dave Peterson

If you're only doing one formula, then copy from the formulabar--and paste into
the formulabar.

If you have lots of cells, change the formulas to text.

Select all the cells
edit|replace
what: = (equal sign)
with: $$$$$=
replace all

Then do the copy

And then do the edit|replace in reverse -- in both the original worksheet and
the new worksheet.
 
Top