Item logo image for SheetKeys

SheetKeys

Featured
5.0(

13 ratings

)
ExtensionTools620 users
Item video thumbnail
Item media 2 screenshot

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.

Review's profile picture

ClĂȘnio LuizNov 18, 2024

PERFECT

Review's profile picture

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

Review's profile picture

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

2 out of 2 found this helpful

Details

  • Version
    0.5
  • Updated
    July 13, 2024
  • Offered by
    philcrosby
  • Size
    47.39KiB
  • Languages
    English
  • Developer
    Email
    sheetkeys-store@googlegroups.com
  • Non-trader
    This 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

The developer has disclosed that it will not collect or use your data. To learn more, see the developer’s privacy policy.

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

Google apps