How to quickly find out the cells that contain formulas?
Shortcut to quickly display formulas.
To quickly display formulas in worksheet, press CTRL + ~
To display values, press CTRL + ~ again.
This would display all cells that contain formulas. If your worksheet is protected then pressing CTRL + ~ would not display the formulas but cells containing formulas can be identified by an increase in column width.
Tuesday, February 13, 2007
Display formulas
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment