View Single Post
  #3   Report Post  
Jay
 
Posts: n/a
Default

When copying an Excel worksheet from one spreadsheet to another, how
does one copy only formulas and no values ? Using the copy, paste
special/formulas always includes the values.


Maybe a two-step process will meet your need.

1. Do an ordinary copy/paste, getting both values and formulas.

2. Get rid of the values by doing:
Edit Go to Special Constants
Hit the Delete key