Shift Command Arrow
Learn how to efficiently select cells in Google Sheets using the Shift + Command keyboard shortcuts to navigate until the next blank cell.
stop scrolling, stop clicking and trying to select part of this. i'm gonna show you a really quick keyboard shortcut . It's Shift, Command, hold those down And Then just click these arrows So of course you can select the entire column , but sometimes we don't wanna select the entire column , we just wanna select the part that's up until the next blank cell. So I'm on B2. I'm gonna hit Shift+Command+Down. gets you there. One more pops over that blank. Another Shift+Command+Down gets you the rest here. You can also do Shift+Command+Right Arrow, and there we got that row. Not the entire row , 'cause of course you can just click there, but we Basic Keyboard Shortcuts To Speed Up Your Productivity How To Add Columns in Google Sheets What's your favorite keyboard shortcut?
got the row until a blank cell Move Blank Rows Move Blank Rows How to Delete Every Blank Row