| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop and drag is copying values instead of formulas
Why would this happen?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Drop and drag is copying values instead of formulas
Have you filtered your data?
joel1972 wrote: Why would this happen? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Drop and drag is copying values instead of formulas
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Drop and drag is copying values instead of formulas
If you have, show all of it before dragging.
Dave Peterson wrote: Have you filtered your data? joel1972 wrote: Why would this happen? -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I drag & drop cell text only | New Users to Excel | |||
| How do I set cell drag and drop to be on as a default | Excel Discussion (Misc queries) | |||
| drag and drop formulas | Excel Discussion (Misc queries) | |||
| Prevent Drag & Drop | Excel Discussion (Misc queries) | |||
| cell drop and drag | Excel Worksheet Functions | |||
Linear Mode
