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

Do you think ride and car sharing are the future of transportation?

Discuss in The Lounge

Poll History