Solution: Excel drag to “fill” not working – value is copied, formula ignored

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:

  1. Click on “Formulas” from the ribbon menu
  2. Expand “Calculation options”
  3. Change “Manual” to automatic

All of your calculations should now be done correctly.

Additional troubleshooting

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.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.