Media
2 items
Description
SheetKeys adds powerful keyboard shortcuts to Google Sheets, in the spirit of the Vim text editor. If you are a project manager, programmer, finance person, or just someone who uses spreadsheets a lot, this can greatly increase your efficiency in Google Sheets. After installing, you can see and customize all of the keyboard mappings by typing "?" while on a Google Sheets page. Here is a partial list of shortcuts, and their default key assignments: Movement: j Move cursor down k Move cursor up h Move cursor left l Move cursor right <C-J> Move rows down <C-K> Move rows up <C-H> Move columns left <C-L> Move columns right <C-d> Scroll half page down <C-u> Scroll half page up g,g Scroll to the top of the sheet G Scroll to the bottom of the sheet Selection: v Begin selecting cells V Begin selecting rows A-v Begin selecting columns Editing: i Edit cell a Append to cell (edit but, starting at the end) u Undo <C-r> Redo o Insert a row below the cursor and edit it O Insert a row above the cursor and edit it s Insert a row below the cursor S Insert a row above the cursor d,d Delete the current row (or selected rows/columns) x Delete cell contents y,y Copy the current row (or selected rows/columns) y,c Copy cells p Paste Formatting: ;,a,l Align left ;,a,c Align center ;,a,r Align right ;,w,w Wrap cell ;,w,w Overflow the cell ;,w,c Clip the cell Other: ? Show the help dialog ;,w,f Toggle full screen ;o Open URL in cell in a new tab