To save a partially-constructed formula, or to inspect a formula outside of the cell in which it resides, simply put a single quote mark ( ‘ ) in front of the equals sign. In the eyes of Excel, this converts the entire formula into text. When you are done reviewing/editing the formula and want to make it live again, just delete the quote mark and hit Enter.
Mar
03