~gentleman on the streets, freak in the spreadsheetsĮDIT: You can get rid of the Enable Editing banner with alt-f-i-e or you can create your own quick access toolbar, so no, there is literally never a reason to use the mouse. That's my "locked up behind xanax bars" fill In excel - alt-h-o-e-f-f-tab-tab-tab-tab-tab-down-down-right-enter-tab-enter Investment bankers are judged for using the mouse when using excel. There are just too many good ones - get used to not modeling with a mouse, force yourself to hit alt and follow the letters on the ribbon to find what you need - after 2-3 months you'll learn all the commonly used ones. (The office being the exception but I still. ctrl-arrow key helps navigate through text much quicker - throw in a shift to highlight what you're navigating through. windows+L to lock the computer - happens to be the perfect fit for pinkie and thumb with 1 hand.
#Mouseless excel windows#
ctrl9/ctrl0 and shiftctrl9/0 for hiding and unhiding rows/columns - you might need to change language settings on windows if its not picking up the unhide columns. ctrl-w to close tabs, ctrl-w-tab-space to close docs without saving (no tab/space to save). When you are done with the comment, press the ESC key to close the comment.
With statistical functions, you are required to add only a range. Don't like where it is positioned Don't touch that mouse Just press the ESC key and use the arrow keys on your keyboard to move the comment around. In Excel, mortgage payments are conveniently calculated through the PMT (payment) function. windows+arrow keys to move windows, alt-tab to tab through programs, windows key+type name of program to open shit. To quickly insert a comment in the current cell, simply pressSHIFT+F2 and start typing. Mo mouse mo problems - ne touche pas.Įverything should/can be mouseless and faster. Mouse is never quicker - first you have to take it out of your desk, then put batteries in it, turn it on, sync it to bluetooth, then you can start clicking like an intern. alt-e-s-f is paste formula rookie - spend some time in the alt-e-s menu - will save you years over your career.