Thread: Drop and drag is copying values instead of formulas
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Drop and drag is copying values instead of formulas
Not clear what is happening from your description, but maybe you are in Manual
calculation mode?

ToolsOptionsCalculation. Check Automatic.


Gord Dibben MS Excel MVP


On Fri, 15 Sep 2006 10:58:02 -0700, joel1972
wrote:

No. I highlight a number of cells, and then attempt to drag the formulas
down. The odd part is, the formulas (v-lookups) will drag down correctly,
but the values of the highlighted cells are what appears.

"Dave Peterson" wrote:

Have you filtered your data?

joel1972 wrote:

Why would this happen?

--

Dave Peterson


Gord Dibben MS Excel MVP
Reply With QuoteReply With Quote