| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy formulas without associated values
How does one copy only the formulas in a given selection without the values
present. For example lets say....a1 = 5; b1=a1+2...if I copy a1 and b1 and use paste special "formulas" to copy those two cells to another location, the first cell has 5 appearing even though it is a value and not a formula. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy between worksheets does not copy formulae just values | Excel Discussion (Misc queries) | |||
| copy worksheet to a new workbook with formulas .... but new file not point to old one | Excel Discussion (Misc queries) | |||
| Copy WITHOUT adjusting values | Excel Worksheet Functions | |||
| copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Worksheet Functions | |||
| how do I make a copy of a worksheet and retain formulas but not data | Setting up and Configuration of Excel | |||
Threaded Mode
