What is your favorite overlooked Excel feature?

[ejanes]

There are so many things we can do in Excel, and I was wondering what some features, functions are, etc that people don't seem to talk about that are really useful!

 

[bobsan42]

IMHO: Keyboard Shortcuts, Accelerators - basically any way to move around and do things faster and more efficiently.
And not just for Excel, but for everything - everyone's clicking their mouse buttons as if their lives depend on it.