Software

Formulas? What formulas? I don't see any formulas!

Ever wished for an easier way to see those sneaky formulas in your Excel spreadsheet instead of clicking on the individual cells? Check out this magic trick one of our readers shared with us.

As I was reading through the TrainingRepubic e-mails and forums, I came across one that really caught my eye. One of our readers, Lofton Delgado, provided an excellent trick of the trade for Excel spreadsheets. This is one tip all trainers need to add to their bag of magic tricks for training in Excel.

So what’s the tip?
Here’s what Lofton had to say about Excel spreadsheet formulas:

“In the manufacturing environment where I teach, Excel spreadsheets become quite large and complex. Frequently a spreadsheet contains many formulas spread throughout. Normally, it is not possible to see all the cells that contain formulas and what the formulas are at a glance. However, if you press the control key and hold it down while pressing the tilde key [~], the spreadsheet shows all cells that contain formulas as well as the formulas themselves. This is also a printable view, so having displayed the formulas, you can print the spreadsheet for easy reference. To reverse the process simply press [Ctrl] and [~] again, and voila, the spreadsheet is back in original form. Hope you can use this.”

Thanks, Lofton, for sharing this tip with us.
If you have a trick you’d like to share with your fellow trainers, please let us know. Check out the forums and share your insight with us. Follow this link to write to us.