Forum Discussion
Favorite feature or tips / tricks you use in Excel
Daniel Courtney , that https://www.tandfonline.com/doi/full/10.1080/00031305.2017.1375989 is recommended reading.
As for shortcuts/mouse I don't thing we shall avoid one or another, it depends on tasks. Reasonable combination works fine.
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