Google Sheets Keyboard Shortcuts

Google Sheets

Common actions

control + spaceSelect column
shift + spaceSelect row
command + shift + spaceSelect all
command + zUndo
command + shift + z or command + yRedo
command + fFind
command + shift + hFind and replace
command + enterFill range
command + dFill down
command + rFill right
command + sSave
command + oOpen
command + pPrint
command + cCopy
command + xCut
command + vPaste
command + shift + vPaste values only
command + /Show common keyboard shortcuts
control + shift + fCompact controls
command + shift + kInput tools on/off (available in spreadsheets in non-Latin languages)
command + option + shift + kSelect input tools
option + /Search the menus

Format cells

command + bBold
command + uUnderline
command + iItalic
option + shift + 5Strikethrough
command + shift + eCenter align
command + shift + lLeft align
command + shift + rRight align
option + shift + 1Apply top border
option + shift + 2Apply right border
option + shift + 3Apply bottom border
option + shift + 4Apply left border
option + shift + 6Remove borders
option + shift + 7 or command + shift + 7Apply outer border
command + kInsert link
command + shift + ;Insert time
command + ;Insert date
command + option + shift + ;Insert date and time
control + shift + 1Format as decimal
control + shift + 2Format as time
control + shift + 3Format as date
control + shift + 4Format as currency
control + shift + 5Format as percentage
control + shift + 6Format as exponent
command + \Clear formatting

Navigate spreadsheet

fn + leftMove to beginning of row
command + fn + leftMove to beginning of sheet
fn + rightMove to end of row
command + fn + rightMove to end of sheet
command + backspaceScroll to active cell
option + downMove to next sheet
option + upMove to previous sheet
option + shift + kDisplay list of sheets
option + enterOpen hyperlink
option + shift + xOpen Explore
command + option + ,Go to side panel
control + command + shift + mMove focus out of spreadsheet
option + shift + qMove to quicksum (when a range of cells is selected)
holding control + command , press e then pMove focus to popup (for links, bookmarks, and images)
control + command + rOpen drop-down menu on filtered cell
command + option + shift + hOpen revision history
shift + escapeOpen chat inside the spreadsheet
command + escape or shift + escapeClose drawing editor

Edit notes and comments

shift + f2Insert/edit note
command + option + mInsert/edit comment
command + option + shift + aOpen comment discussion thread
holding control + command , press e then cEnter current comment
holding control + command , press n then cMove to next comment
holding control + command , press p then cMove to previous comment

Open a menu

control + option + fFile menu
control + option + eEdit menu
control + option + vView menu
control + option + iInsert menu
control + option + oFormat menu
control + option + dData menu
control + option + tTools menu
command + option + = with cells selectedOpen insert menu
command + option + - with cells selectedOpen delete menu
control + option + mForm menu (present when the spreadsheet is connected to a form)
control + option + nAdd-ons menu
control + option + hHelp menu
control + option + aAccessibility menu (present when screen reader support is enabled)
option + shift + sSheet menu (copy, delete, and other sheet actions)
command + shift + \Context menu

Add or change rows and columns

command + option + = with rows selected/ctrl+opt+i rInsert rows above
control + option + i then bInsert rows below
command + option + = with columns selected/ctrl+opt+i cInsert columns to the left
control + option + i then oInsert columns to the right
command + option + -Delete rows
command + option + -Delete columns
command + option + 9Hide row
command + option + 0Hide column
option + shift + rightGroup rows or columns
option + shift + leftUngroup rows or columns
option + shift + downExpand grouped rows or columns
option + shift + upCollapse grouped rows or columns

Use formulas

control + ~Show all formulas
command + shift + enterInsert array formula
command + eCollapse an expanded array formula
shift + fn + f1Show/hide formula help (when entering a formula)
fn + f1Full/compact formula help (when entering a formula)
fn + f4Absolute/relative references (when entering a formula)
fn + f9Toggle formula result previews (when entering a formula)
control + option + up or control + option + downResize formula bar (move up or down)

Help for screen readers

command + option + zTurn on screen reader support
command + option + shift + cRead column
command + option + shift + rRead row