ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   copy formulas without associated values (https://www.excelbanter.com/excel-worksheet-functions/81277-copy-formulas-without-associated-values.html)

dranreb

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.


All times are GMT +1. The time now is 07:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com