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
Latest reviews
- (2023-03-03) Tuấn Hải Lê: Great so far
Statistics
Installs
618
history
Category
Rating
5.0 (13 votes)
Last update / version
2024-07-13 / 0.5
Listing languages
en