Some times when we are working in Excel, we want to study the pattern of the formulas. Why does the first function work but not the following. What has changed in the pattern of the function. This is particularly helpful when working with Absolute Cell Referencing.
To reveal all formulas created in Excel.
Press Ctrl ~ or go to the Formulas Tab and Select Show Formulas.
Face to Face training available Sydney – Australia firstname.lastname@example.org