Drill down into Excel formula to see resultant numbers

Another common problem is looking at a big formula, and understanding how it works. It is sometimes easier to look at the numbers instead of just staring at the references. This trick allows you to see what the cell reference number is without you having to shoot around the spreadsheet trying to track the numbers down.

To follow along go to 3.1

 

Back to: Free Excel Tips and Tricks