SUMMARY

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

The latest version of SheetKeys is available on the Chrome web and is currently being used by 551 active users. The initial version was launched on 2023-02-16.

HOW TO INSTALL SheetKeys FROM A CRX FILE

1. Download SheetKeys CRX file
2. NOTE: Sometimes the browser may block downloading / installing CRX file from outside the Chrome Web Store. If so, you may need to download the ZIP file instead
3. In the URL bar, go to chrome://extensions
4. Enable Developer mode

Ratings

USER REVIEWS (0)