#5 / 12 rate

SheetKeys

525 users

2023-02-16

philcrosby

sheetkeys-store@google...

Extension Information

5 star

100%

4 star

3 star

2 star

1 star

Supported Languages

Permissions

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

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

Reviews

Bhira Wongseyai

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 Sheets!

Joohan Lee

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