To copy and paste a formula or drag a formula now only pastes the.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

All of a sudden when I drag a formula, or copy and paste a formula, only the
value of the first cell is displayed, although the formula shows in the new
cells. I have to actually click on F2 to activate the formula and have it
calculate the appropriate values.
 
How is calculation set? Tools>options>calculation

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Back
Top