Connecting Technology and Business.


We know that a formula in a cell is also displayed in the formula bar of the Excel interface. How about displaying all formulae in a worksheet all at a time so that, many times, it helps editing one or more formula in various cells easily?

The secret lies in a button that is placed usually just below the Esc key on your keyboard. This "~" symbol is called "Tilde". Use this with a Ctrl key and immediately Excel displays all the formulae in the worksheet. Use this same key combination again and you will see the results of these formulae in the cells. Ctrl+ ~ toggles between formulae and result in the cells of a worksheet. Make sure to return to the results display mode or you will see some features not functioning as expected.