Note: Video of solution at bottom of post.
A client of mine recently ran into an issue I hadn’t seen before. When she would click a formula cell and drag down to calculate it across multiple rows, it only copied the value. The formulas were correct, but the value being shown was from the original cell:
Somehow, sheet calculation had been set to manual. To fix this issue:
- Click on “Formulas” from the ribbon menu
- Expand “Calculation options”
- Change “Manual” to automatic
All of your calculations should now be done correctly.
If you’re still having an issue with drag-to-fill, make sure your advanced options (File –> Options –> Advanced) have “Enable fill handle…” checked.
You might also run into drag-to-fill issues if you’re filtering. Try removing all filters and dragging again.