XLKeys

Google Sheets Shortcut Cheat Sheet

Every native Google Sheets shortcut + every XLKeys Excel-style shortcut. Print it, tape it to your monitor, never reach for the mouse again.

xlkeyz.com

v1.0

Shortcuts shown for Windows.

On Mac, swap Ctrl → ⌘ and Alt → Option.

Section 1 — Native Google Sheets shortcuts

From Google's official keyboard shortcuts reference

Essentials

Show all keyboard shortcuts

Ctrl+/

Tool finder (search menus)

Alt+/

Undo

Ctrl+Z

Redo

Ctrl+Y

Find

Ctrl+F

Find and replace

Ctrl+H

Save

Ctrl+S

Ctrl+P

Compact controls (hide menus)

Ctrl+Shift+F

Edit & Fill

Cut

Ctrl+X

Copy

Ctrl+C

Paste

Ctrl+V

Paste values only

Ctrl+Shift+V

Fill down

Ctrl+D

Fill right

Ctrl+R

Fill range

Ctrl+Enter

Insert link

Ctrl+K

Insert date

Ctrl+;

Insert time

Ctrl+Shift+;

Insert date and time

Ctrl+Alt+Shift+;

Selection

Select column

Ctrl+Space

Select row

Shift+Space

Select all

Ctrl+A

Extend selection one cell

Shift+Arrow

Extend selection to edge of data

Ctrl+Shift+Arrow

Select current region

Ctrl+Shift+*

Navigation

Move to edge of data

Ctrl+Arrow

Move to beginning of row

Home

Move to end of row

End

Move to beginning of sheet

Ctrl+Home

Move to end of sheet

Ctrl+End

Scroll to active cell

Ctrl+Backspace

Next sheet

Alt+Down

Previous sheet

Alt+Up

Display list of sheets

Alt+Shift+K

Open hyperlink

Alt+Enter

Go to range

Ctrl+G

Formatting

Bold

Ctrl+B

Italic

Ctrl+I

Underline

Ctrl+U

Strikethrough

Alt+Shift+5

Center align

Ctrl+Shift+E

Left align

Ctrl+Shift+L

Right align

Ctrl+Shift+R

Clear formatting

Ctrl+\

Number Formats

Format as decimal

Ctrl+Shift+1

Format as time

Ctrl+Shift+2

Format as date

Ctrl+Shift+3

Format as currency

Ctrl+Shift+4

Format as percentage

Ctrl+Shift+5

Format as exponent

Ctrl+Shift+6

Borders

Top border

Alt+Shift+1

Right border

Alt+Shift+2

Bottom border

Alt+Shift+3

Left border

Alt+Shift+4

Remove borders

Alt+Shift+6

Outer border

Alt+Shift+7

Rows & Columns

Open insert menu

Ctrl+Alt+=

Open delete menu

Ctrl+Alt+−

Hide row

Ctrl+Alt+9

Unhide row

Ctrl+Shift+9

Hide column

Ctrl+Alt+0

Unhide column

Ctrl+Shift+0

Group rows/columns

Alt+Shift+Right

Ungroup rows/columns

Alt+Shift+Left

Expand grouped

Alt+Shift+Down

Collapse grouped

Alt+Shift+Up

Formulas

Show all formulas

Ctrl+~

Insert array formula

Ctrl+Shift+Enter

Collapse array formula

Ctrl+E

Toggle absolute / relative ref

F4

Show / hide formula help

Shift+F1

Toggle formula result preview

F9

Resize formula bar

Ctrl+Up / Down

Menus (Chrome)

File menu

Alt+F

Edit menu

Alt+E

View menu

Alt+V

Insert menu

Alt+I

Format menu

Alt+O

Data menu

Alt+D

Tools menu

Alt+T

Help menu

Alt+H

Comments & Notes

Insert / edit note

Shift+F2

Insert / edit comment

Ctrl+Alt+M

Open comment thread

Ctrl+Alt+Shift+A

Next comment

J

Previous comment

K

Reply to comment

R

Resolve comment

E

Section 2 — XLKeys Excel-style shortcuts

Install the Chrome extension at xlkeyz.com

Formula Auditing

Trace PrecedentsPro

Ctrl+Shift+[

Trace DependentsPro

Ctrl+Shift+]

Go Back to Last Cell

Alt→G→B

Analysis

Goal SeekPro

Alt→A→W→G

Sensitivity TablePro

Alt→A→W→T

Auto-Color

Auto-Color SelectionPro

Ctrl+Shift+S

Format Cycles

General Number Cycle

Ctrl+Shift+1

Font Color Cycle

Ctrl+'

Fill Color Cycle

Ctrl+Shift+K

Fill Color Picker

Alt→H→H

Number Formats

Percentage

Ctrl+Shift+5

Currency

Ctrl+Shift+4

Date

Ctrl+Shift+3

Time

Ctrl+Shift+2

Accounting

Alt→H→A→N

Scientific

Ctrl+Shift+6

Exponential

Ctrl+Shift+Y

Decimals

Increase Decimals

Alt→H→0

Reduce Decimals

Alt→H→9

Borders

Top Border

Alt→H→B→P

Bottom Border

Alt→H→B→O

Left Border

Alt→H→B→L

Right Border

Alt→H→B→R

Outside Border

Alt→H→B→S

All Borders

Alt→H→B→A

Remove Borders

Alt→H→B→N

Top and Bottom

Alt→H→B→D

Thick Outside

Alt→H→B→T

Bottom Double

Alt→H→B→B

Top + Bottom Double

Alt→H→B→U

Alignment

Indent Cycle

Alt→H→6

Align Center

Alt→H→A→C

Align Left

Alt→H→A→L

Align Right

Alt→H→A→R

Align Top

Alt→H→A→T

Align Middle

Alt→H→A→M

Align Bottom

Alt→H→A→B

Font

Set Font

Alt→H→F→F

Set Font Size

Alt→H→F→S

Increase Font Size

Alt→H→F→G

Decrease Font Size

Alt→H→F→K

Set Font Color

Alt→H→F→C

Resize Rows & Columns

Set Column Width

Alt→H→O→W

Autofit Column Width

Alt→H→O→I

Set Row Height

Alt→H→O→H

Autofit Row Height

Alt→H→O→A

Freeze & Unfreeze

Freeze Rows & Columns

Alt→W→F→F

Unfreeze Rows & Columns

Alt→W→F→U

Freeze Columns

Alt→F→C

Unfreeze Columns

Alt→W→F→C

Freeze Rows

Alt→F→R

Unfreeze Rows

Alt→W→F→R

Merge & Unmerge

Merge All

Alt→H→M→A

Unmerge All

Alt→H→M→U

Insert & Delete

Insert Columns / Rows

Ctrl+Shift+=

Delete Columns / Rows

Ctrl+Shift+−

Paste Special

Open Paste Special Menu

Alt→E→S

Paste Values

Alt→E→S→V

Paste Formulas

Alt→E→S→F

Paste Formatting

Alt→E→S→T

Paste Transposed

Alt→E→S→E

Paste Column Width

Alt→E→S→W

Paste All Except Borders

Alt→E→S→X

Text Rotation

Tilt Up

Alt→H→F→Q→O

Tilt Down

Alt→H→F→Q→L

Stack Vertically

Alt→H→F→Q→V

Rotate Up

Alt→H→F→Q→U

Rotate Down

Alt→H→F→Q→D

Clear & View

Clear All

Alt→H→E→A

Clear Formatting

Alt→H→E→F

Show / Hide Gridlines

Alt→W→V→G

Add / Remove Filter

Ctrl+Shift+L

Pro= requires XLKeys Pro (30-day free trial, no credit card)Alt sequences: press Alt, release, then type the letters in order.

xlkeyz.com