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 manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History