Copy formulas to text documents

MAGOOGLE

New Member
Joined
Nov 30, 2005
Messages
5
Can anyone tell me how I can copy all the formulas in a selected area of cells and paste them to a text document without the end product being the result of the formula, but the formula itself.
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

nbrcrunch

Well-known Member
Joined
Jan 1, 2003
Messages
2,062
The following worked for me but I suppose it might depend into which application you are pasting:

1. switch to formula-view mode (Ctrl key and the tilde key together)
2. copy the cells
3. Paste into Notepad (or Word)
 

Watch MrExcel Video

Forum statistics

Threads
1,118,760
Messages
5,574,079
Members
412,566
Latest member
TexasTony
Top