SheetKeys adds powerful keyboard shortcuts to Google Sheets, in the spirit of the Vim text editor.

Latest Version

Version

0.5

Update

July 12, 2024

Size

47.39KiB

Developer

SheetKeys Extension

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

Move rows down

Move rows up

Move columns left

Move columns right

Scroll half page down

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

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

Source Manifest.json

{"update_url": "https://clients2.google.com/service/update2/crx", "manifest_version": 3, "name": "SheetKeys", "version": "0.5", "description": "SheetKeys adds powerful keyboard shortcuts to Google Sheets, in the spirit of the Vim text editor.", "permissions": [ "storage" ], "icons": { "48": "icons/icon48.png", "128": "icons/icon128.png" }, "background": { "service_worker": "background_script.js" }, "content_scripts": [ { "matches": [ "https://docs.google.com/spreadsheets/*", "https://docs.google.com/a*/spreadsheets/*" ], "js": [ "content_scripts/keyboard_utils.js", "content_scripts/settings.js", "content_scripts/sheet_actions.js", "content_scripts/ui.js", "content_scripts/commands.js", "help_dialog.js" ], "run_at": "document_end", "all_frames": false } ], "web_accessible_resources": [ { "resources": [ "page_scripts/page_script.js", "fontello_svg_icon_font.css", "help_dialog.css", "help_dialog.html" ], "matches": [ "https://docs.google.com/*" ] } ]}

Download CRX(47.39KiB)