View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default Drop and drag is copying values instead of formulas

Press F9 to recalculate your worksheet.
--
Brevity is the soul of wit.


"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