PC help: How to see Excel cell formulas

Within Excel it is sometimes useful to see the formulas contained in cells.

This is easily accomplished en masse by holding down the Ctrl key while tapping the ` button (which, on most Qwerty keyboards, is just to the left of the ‘1’ key, immediately below the Esc key).

To switch back to data view, just press Ctrl and ` once more. Note also that both Excel’s Find and Replace functions work in the described formula view.

So, if you need to quickly change all formula references in one column, for example, first switch to formula view and then use Find and Replace (from the Edit menu).

Tariq Mohammad