Forum Discussion
Favorite feature or tips / tricks you use in Excel
General conversation starting question here. I just wanted to gain a sense of any features or tactics that you employ in Excel that make the tool more powerful for you. For example I always like ...
SergeiBaklan I agree on the kbd vs mouse debate; some things are pretty much undoable using just the keyboard. But many, many operations in Excel are way more efficient if you learn the keyboard short-cuts. My favorite one is control+1 to bring up the format dialog for any selected object in Excel.
JKPieterse , yes, sure, shortcuts are quite efficient, especially for the routine and day-to-day operations. I'd only like to say what the approach only shortcuts or only mouse is not productive from my point of view.
As for my ones, first in mind and more often used, perhaps Ctrl+1 (of course), Ctrl+T, Ctrl+PgUp/PgDn, Ctrl+D, Ctrl+Shift+Up/Dn,... Majority of them are Ctrl+ or GrCtrl+, and I prefer mouse instead of something like Alt+A+B+C