Paul Barnhurst explains why F2 and F9 are essential spreadsheet shortcuts. F2 lets you edit cell content directly, while F9 evaluates formulas without recalculating the entire sheet. Choose shortcuts based on your actual workflow, not habit.
There are many, many formulas in Excel and Google Sheets, dynamic ranges, but still I love the basics, F2, F9.
Basically, it's not about shortcut, it's the diagnostic mindset. Thinking about myself, like what I'm using a lot. So I think F2 and F9, which I'm using a lot.
So those are the favorite shortcuts, the F2 and F9. Yeah, I get it. F2 is incredibly helpful. F9, if I'm not doing dynamic arrays, I love F4. But as you start making more and more things dynamic, it doesn't matter as much. Microsoft, if you're listening, fix it.
Trust and Leadership Lessons for FP&A From 100+ Top Leaders with CFO Jon Laudie
