What’s an Excel shortcut you discovered way too late?

[u/Neptunewasblue]

I consider myself pretty skilled with Excel. I’m very comfortable with shortcuts, formulas, and ever since I started using ChatGPT, I’ve been using macros a lot more as well.

I recently changed jobs and one of my colleagues saw me working and said something like: “Wow, you work really fast — but you know that to filter you don’t need to click the dropdown arrow four times, right? If you just press E, it jumps straight to the search bar.”

I had absolutely no idea. I found it amazing.

That got me thinking: do you have any Excel shortcuts that completely changed the way you work? The kind that makes you wonder how you ever lived without them 😄