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

N

noradora

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.
 
N

Nick Hodge

How is calculation set? Tools>options>calculation

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Merging from an Excel file with graphics 1
Copy & Paste 3
VB Script reference cells for in current table? 1
Pages are changing pasted image... 0
Would like to input 3 letters into a cell, each having a different numerical value 5
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Office 2007 Excel Paste Special formula only 1

Top