I have filled down a formula in a column on an excel spreadsheet. The new formulas all formatted correctly but I have to click on each cel, the formula bar, and enter before it recalculate formula. I'm guessing this has something to do with how the spreadsheet was created, but I can't find the option to change it!

Check the option settings in Excel.

There you'll find a tab called Calculating.

Make sure, that "Automatic" is aktivated.

Ask Your Question

Weekly Poll