Posted to microsoft.public.excel.misc

J. Sperry[_2_] J. Sperry[_2_] is offline

external usenet poster

Posts: 33

Copying Formulas

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.

"Mac" wrote:

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
copying formulas	mc	Excel Worksheet Functions	2	October 29th 07 10:26 PM
Copying formulas	englishrose4719	Excel Discussion (Misc queries)	5	May 17th 07 04:05 PM
copying formulas	Woody	Excel Discussion (Misc queries)	8	August 21st 06 09:47 PM
copying formulas in vba	Michael	Excel Discussion (Misc queries)	1	November 17th 05 08:48 PM
copying formulas	Mark Goodwin	Excel Worksheet Functions	2	May 11th 05 05:31 PM

All times are GMT +1. The time now is 01:20 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us