| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying formulae
How do I copy a column of formulae as text to a new worksheet?
-- roger finch |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copying formulae
Copy the formula in the f(x) box at the top of the worksheet. Select the
cell the use CNTL - C. go to 2nd worksheet select the cell where you want to pastt the formula and click in f(X) box and type Cntl - V. "roger finch" wrote: How do I copy a column of formulae as text to a new worksheet? -- roger finch |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copying formulae
Hi Roger
One way. Select your column of formulae Ctrl+H to invoke Find and Replace Find = Replace # Replace All Copy your formulae and paste to new sheet. Do a Find and Replace of # with = on both sheets. -- Regards Roger Govier "roger finch" wrote in message ... How do I copy a column of formulae as text to a new worksheet? -- roger finch |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COPYING FORMULAE | Excel Worksheet Functions | |||
| copying formulae along rows. | Excel Discussion (Misc queries) | |||
| copying formulae | Excel Worksheet Functions | |||
| copying and pasting excel formulae | Excel Worksheet Functions | |||
| when copying formulae from one cell to another it does not work | Excel Worksheet Functions | |||
Linear Mode
