| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Copy Formula to Different Workbook
How do I copy a formula from one WORKBOOK to another WORKBOOK? -- rookerr ------------------------------------------------------------------------ rookerr's Profile: http://www.excelforum.com/member.php...o&userid=26588 View this thread: http://www.excelforum.com/showthread...hreadid=398581 |
|
#2
|
|||
|
|||
|
Open both workbooks. Select the cell in the first workbook with the formula you want to copy. Place your cursor on the Formula Bar at the top of the sheet and click and drag to highlight the entire formula. Press Ctrl+C (to copy) then press the Esc key to deselect that cell. Now go to the cell in the second workbook and press Ctrl+V (paste). Done! HTH Bruce -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=398581 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy formula and get value instead | Excel Discussion (Misc queries) | |||
| Copy Paste of Formula Produces Incorrect Result | Excel Discussion (Misc queries) | |||
| How to copy cells with keeping exact formula intact | Excel Discussion (Misc queries) | |||
| how can i copy formula? | Setting up and Configuration of Excel | |||
| copy COLUMN from 1 worksheet to another (in a different workbook) | Excel Discussion (Misc queries) | |||
Linear Mode
