53. Excel Tips - Ways to Calculate in Excel

Nick's picture

This tip is a followon from the previous Excel tip on Calculation

Today, we're going to look at different ways to calculate

There are a few different ways to calculate something in Excel, and you can use each differently.

Q. What do you do if your sheet is not calculating ?
A. The calculation tree works by looking to see if any precedent cells have changed. If the precedent cells have not changed, Excel will not calculate the dependent cells.
If you have a function that builds an object by importing data from a file, it will not calculate unless it's forced to do so. SO.. What do you do if your sheet is not calculating ?... You press CTRL and ALT and F9 TWICE.
CTRL and ALT and F9 forces excel to calculate every cell regardless of whether the precedent cells have changed or not.

Q. How do you calculate selection in Excel ?
A. There's no easy way.. There should be a shortcut combination, but there isn't. The best way to do this is to simply replace = with = and repeat until all cells have been calculated. If none of them are dependent on each other, then you only have to do this once.

Q. How do you calculate Only the active sheet in Excel?
A. This is easy... press SHIFT and F9

Q. How do you calculate the Excel application ?
A. Press F9

Download a spreadsheet to practice different ways to calculate in Excel

Training Video on ways to calculate in Excel: