故事的主人公老王，已经在职场摸爬滚打了十年，每天都在和Excel打交道。但是，今天他碰到了一道难题。在统计各店铺的销售记录时，公式计算出的结果与预期相差甚远：明明10+20+30+40+50应该是150，结果却变成了190。老王百思不得其解，使用的公式看上去没有问题——=SUM (F2:F7)。

This can ruin a beautiful excel model. And it can take awhile to fix because you have to find the problem cell. The F5 key saves time in Excel by letting you jump to specific cells or named ranges.

This can ruin a beautiful excel model. And it can take awhile to fix because you have to find the problem cell. The F5 key saves time in Excel by letting you jump to specific cells or named ranges.