| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pasting formulas but not the links help needed
How can I paste a formula onto a seperate spreadsheet from a template I
made but not have the link from the template included in the formula? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pasting formulas but not the links help needed
If it's just one cell, I copy it from the formula bar and paste into the formula
bar. If it's a bunch of cells, I do this: Select the range to copy edit|Replace what: = with: $$$$$ replace all Do the copy|paste while my "formulas" are just text. Tnen reverse it (in both locations). edit|Replace what: $$$$$ with: = replace all And the Text formulas will change back to formula formulas. wrote: How can I paste a formula onto a seperate spreadsheet from a template I made but not have the link from the template included in the formula? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pasting formulas but not the links help needed
It works. Thanks for the help
Dave Peterson wrote: If it's just one cell, I copy it from the formula bar and paste into the formula bar. If it's a bunch of cells, I do this: Select the range to copy edit|Replace what: = with: $$$$$ replace all Do the copy|paste while my "formulas" are just text. Tnen reverse it (in both locations). edit|Replace what: $$$$$ with: = replace all And the Text formulas will change back to formula formulas. wrote: How can I paste a formula onto a seperate spreadsheet from a template I made but not have the link from the template included in the formula? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pasting formulas without the link help | Excel Discussion (Misc queries) | |||
| Pasting formulas to different rows | Excel Worksheet Functions | |||
| Pasting formulas problem | Excel Discussion (Misc queries) | |||
| Links in formulas change when another user runs a workbook | Excel Discussion (Misc queries) | |||
| pasting formulas into a selection | Excel Worksheet Functions | |||
Linear Mode
