Display & Hide Formulas

At times, we want to verify formula correctness by looking at the formulas. While we can look at the formula of a specific by clicking on it, Excel provides the functionality to make all formulas visible in the worksheet-


Keyboard shortcut for Hiding & Unhiding Formulas in Excel worksheets -


1. To show formula/s in Excel worksheets, Press CTRL + ~


 


2. To revert back to normal mode, Press CTRL+~ again, this will hide formula and display formula results in the cells.