The problem with posts about keyboard shortcuts is that I list ten or twenty of them and exactly none of them stick. So I’m just doing one.
If you have to select a long column of data, using the mouse can take a while. And if I’m sitting behind you in your office trying to help you with your spreadsheet, I really don’t want to wait for you to select 1,000 cells with your mouse. Hey, I’m a busy guy. That’s why I think that if you only know one keyboard shortcut, it should be Control+Shift+ArrowKey.
In this video, I select ~200 cells with the mouse. Then I select B2 and select those same cells by holding down the Ctrl and Shift keys and pressing the down arrow.
I’m sure you’ll agree that the second method is much quicker. And you won’t have to hear me sigh in a melodramatic fashion when you select long columns with your mouse.
I need a screen capture program that also captures the keypresses and scrolls them across the bottom of the screen. There’s a million dollar idea for you.
If you could force your coworkers to use one keyboard shortcut, what would it be?