J
joel1972
Why would this happen?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
Have you filtered your data?
Why would this happen?
J
joel1972
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.
down. The odd part is, the formulas (v-lookups) will drag down correctly,
but the values of the highlighted cells are what appears.
D
Dave Peterson
If you have, show all of it before dragging.
Dave said:Have you filtered your data?
D
Dave F
Press F9 to recalculate your worksheet.
G
Gord Dibben
Not clear what is happening from your description, but maybe you are in Manual
calculation mode?
Tools>Options>Calculation. Check Automatic.
Gord Dibben MS Excel MVP
Gord Dibben MS Excel MVP
calculation mode?
Tools>Options>Calculation. Check Automatic.
Gord Dibben MS Excel MVP
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.
Gord Dibben MS Excel MVP