Copying Formulas

G

Gingerly

When I copy a formula from one spreadsheet to another (2 different files, not
worksheets within the same file), the file name of the spreadsheet that I am
copying FROM is copied to the cell of the spreadsheet that I am copying TO. I
only want the formula itself, not the spreadsheet name. I tried PASTE
SPECIAL but it didn't work. Thanks in advance for any help.
 
T

trip_to_tokyo

In EXCEL 2007 when doing the Paste Special select the Formulas radio button
then hit OK and you will get just the formula without the spreadsheet name.

If my comments have helped please hit Yes.
 

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

Why paste between workshhets yields values only 6
Auto Fill Format or Copying Formulas 1
Copying formulas from Excel 2003 to Excel 2007 4
Copy and paste values, formatting and formulas 2
copying a formula 1
Cell shows the last typed text, no matter where it is typed 0
Copying formulas from file to file 2
Zip Code formatting problem 3

Top