View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dranreb
 
Posts: n/a
Default 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.