Excel formulas are a powerful way to quickly manipulate and display the data in your spreadsheets to your exact specifications. Once you've created an effective formula for your data, you may want ...

From now onwards, Excel will display the formula in all cells instead of the calculated results. Note: If you want to show the results again in all cells, you need to disable this setting.