Hi again, folks...
Okay. As I continue to explore the many fun things Excel can do, once again I've run into something I can't figure out alone.
On the Tools drop-down menu, there's a selection called Options. When I click on this, it brings up a dialog box with eight or so different tabs on it. The second of these tabs is marked Calculations.
When I open this tab, it gives me a choice of either having automatic calculations or manual calculations. I tried entering in some numbers in a range of cells and getting it to calculate the sum, but it didn't seem to do anything.
So essentially, my question is, what do I need to do to make this work? Is the fact that it's automatically set for automatic calculation telling me that once I enter a formula, it will automatically do the calculating without my having to even go to this option? Or am I missing a step somewhere?
Thanks in advance for any help you can give!
David
Okay. As I continue to explore the many fun things Excel can do, once again I've run into something I can't figure out alone.
On the Tools drop-down menu, there's a selection called Options. When I click on this, it brings up a dialog box with eight or so different tabs on it. The second of these tabs is marked Calculations.
When I open this tab, it gives me a choice of either having automatic calculations or manual calculations. I tried entering in some numbers in a range of cells and getting it to calculate the sum, but it didn't seem to do anything.
So essentially, my question is, what do I need to do to make this work? Is the fact that it's automatically set for automatic calculation telling me that once I enter a formula, it will automatically do the calculating without my having to even go to this option? Or am I missing a step somewhere?
Thanks in advance for any help you can give!
David