Sam, of Phoenix asks, "I work with large spreadsheets in Excel and sometimes find it difficult to remember what formulas are calculating which cells. Is there an easy way to see all of the formulas?"
The wonderful answer is "Yes, you can see Excel formulas revealed!"
This is such an easy tip that has tremendous value and I ask everyone to share it with every Excel user you know.
Within your Excel spreadsheet, simply press the "CTRL" key and the "Tilda" key.
HINT: The "Tilda" key (~) is the key just to the left of the number "1" key on the keyboard.
Pressing "CTRL + Tilda" reveals all Excel formulas on your spreadsheet.
Simply press "CTRL + Tilda" again to hide the formulas and show the results.
Keep this Excel tip handy and you'll come to love large Excel spreadsheets. Or at least tolerate them.
--------------------------------------------------
To receive notifications on all of my articles, click the "Subscribe" button at the top of this page.
As usual, if you have questions or ideas for articles, "Go Ask Debbie!"
Also, be sure to follow me on Facebook.
-------------------------------------------------
Comments