Google Sheets All Shortcut Keys

Basic Shortcuts (Ctrl Key)

Shortcut	Action
Ctrl + A	Select all
Ctrl + B	Bold
Ctrl + C	Copy
Ctrl + D	Fill down
Ctrl + E	Expand array formula
Ctrl + F	Find
Ctrl + H	Find & Replace
Ctrl + I	Italicize text
Ctrl + K	Insert link
Ctrl + P	Print
Ctrl + S	Save
Ctrl + U	Underline
Ctrl + V	Paste
Ctrl + X	Cut
Ctrl + Z	Undo

Shortcuts with Alt Key

Shortcut	Action
Alt + D	Open Data menu
Alt + E	Edit menu
Alt + F	File menu
Alt + I	Insert menu
Alt + T	Tools menu
Alt + V	View menu
Alt + H	Help menu

Shortcuts with Alt + Shift

Shortcut	Action
Alt + Shift + 1	Apply top border
Alt + Shift + 2	Apply right border
Alt + Shift + 3	Apply bottom border
Alt + Shift + 4	Apply left border
Alt + Shift + 5	Strikethrough text
Alt + Shift + 6	Remove borders
Alt + Shift + 7	Apply outer border
Alt + Shift + 8	Compact controls

Shortcuts with Ctrl + Shift

Shortcut	Action
Ctrl + Shift + 1	Format as decimal
Ctrl + Shift + 2	Format as time
Ctrl + Shift + 3	Format as date
Ctrl + Shift + 4	Format as currency
Ctrl + Shift + 5	Format as percentage
Ctrl + Shift + 6	Format as exponent
Ctrl + Shift + V	Paste values only

Mac Formatting Shortcuts

Shortcut	Action
Option + Shift + 1	Apply top border
Option + Shift + 2	Apply right border
Option + Shift + 3	Apply bottom border
Option + Shift + 4	Apply left border
Option + Shift + 6	Remove borders

Google Sheets Shortcut Keys

Shortcut	Action
Ctrl + A	Select all
Ctrl + B	Bold text
Ctrl + C	Copy
Ctrl + D	Fill down
Ctrl + E	Open the Explorer panel
Ctrl + F	Find text
Ctrl + G	Go to a specific cell
Ctrl + H	Find and replace
Ctrl + I	Italicize text
Ctrl + J	Align text to justify
Ctrl + K	Insert link
Ctrl + M	Insert a new comment
Ctrl + N	Create a new spreadsheet
Ctrl + O	Open an existing file
Ctrl + P	Print
Ctrl + Q	Quit the application
Ctrl + R	Fill right
Ctrl + S	Save the spreadsheet
Ctrl + T	Create a table
Ctrl + U	Underline text
Ctrl + V	Paste
Ctrl + X	Cut
Ctrl + Y	Redo the last action
Ctrl + Z	Undo the last action
Ctrl + Shift + L	Apply a filter
Alt + Shift + 5	Strikethrough text
Ctrl + Shift + 7	Add a border around selected cells
Ctrl + ;	Insert the current date
Ctrl + Shift + :	Insert the current time
Ctrl + Shift + K	Insert a new link
Ctrl + \	Remove formatting
Ctrl + Enter	Fill selected cells with the current entry
Alt + Enter	Insert a new line within a cell
F2	Edit the active cell
Shift + Arrow Keys	Select multiple cells
Ctrl + Shift + V	Paste without formatting
Ctrl + Shift + Z	Redo an action (alternative)
Ctrl + Alt + Shift + H	View edit history
Ctrl + Alt + Shift + M	Open comment history