Overview
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
5 out of 513 ratings
Google doesn't verify reviews. Learn more about results and reviews.
ClĂȘnio LuizNov 18, 2024
PERFECT
Bhira WongseyaiAug 6, 2024
The extension works really well I really loved it. If there's something to improve upon the current version IMO would be 1. Ctrl(CMD)+ Arrow Keys to jump to the last blank / non blank cell 2. Highlighting cell (To perform this with keyboard is really tedious, you have to ctrl+option+t to go to the toolbar then 'a' to accessibility then you'd tab all the way to highlight bar then select the colour.... you get the idea). Thank you guys for all the effort making vim motions work in Google She... Show more
Joohan LeeJul 18, 2024
can't believe i found this just now. Thank you so much. If possible could you add a function for shortcut to toggling filter? That would be absolutely amazing to do just by entering a key
Details
- Version0.5
- UpdatedJuly 13, 2024
- Offered byphilcrosby
- Size47.39KiB
- LanguagesEnglish
- Developer
Email
sheetkeys-store@googlegroups.com - Non-traderThis developer has not identified itself as a trader. For consumers in the European Union, please note that consumer rights do not apply to contracts between you and this developer.
Privacy
This developer declares that your data is
- Not being sold to third parties, outside of the approved use cases
- Not being used or transferred for purposes that are unrelated to the item's core functionality
- Not being used or transferred to determine creditworthiness or for lending purposes
Support
For help with questions, suggestions, or problems, please open this page on your desktop browser