| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to copy formulas from one workbook to another
I am trying to copy formulas from one workbook into another. I highlited the
desired cells, selected ctrl c, opened the new workbook and selected ctrl v. It copied the values in the first workbooks cells, but not the formulas. Any idea what I am doing wrong? |
|
#2
|
|||
|
|||
|
Use "Paste Special" from Edit menu.
"Confused" wrote: I am trying to copy formulas from one workbook into another. I highlited the desired cells, selected ctrl c, opened the new workbook and selected ctrl v. It copied the values in the first workbooks cells, but not the formulas. Any idea what I am doing wrong? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What's the simplest way to copy data from another workbook | Excel Worksheet Functions | |||
| copy COLUMN from 1 worksheet to another (in a different workbook) | Excel Discussion (Misc queries) | |||
| copy a workbook from other workbook with lot of sheets wit... | Excel Discussion (Misc queries) | |||
| how do I make a copy of a worksheet and retain formulas but not data | Setting up and Configuration of Excel | |||
| copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions | |||
Linear Mode
