as promised-- excel tips (round 1)

In truth, the inspiration for this blog was to disseminate the nuggets of excel wisdom I'm gaining in my excel modeling class. Here are the new tips from last night:

• F2 will highlight the inputs of any given formula
• ctrl~ will show all of the formulas (very very very very very very useful)
  
• F4 will freeze a cell (put in the $ signs, rather than you having to do it manually)
• =SLN will do straight line depreciation

Feel free to share some of yours if you have any!