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?
 
J

J. Sperry

Select and copy the formula in the formula bar. Be sure to hit <Escape>
after copying so you don't actually change the formula in the original cell.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

problems getting this macro to work 23
Copying Formulas 2
Excel Help to copy information from one row at a time to another sheet 1
Auto Fill Format or Copying Formulas 1
Copy and Paste Question 12
Excel Question 1
Why paste between workshhets yields values only 6
Copy worksheet to new doc w/formulas not referencing previous doc 4

Top