200 Excel Shortcuts for PC and Mac

Learn Microsoft Excel Download PDF

Formatting Text and Numbers – Microsoft Excel Shortcuts

Formatting Text and Numbers

Simple shortcuts to help you edit your content down to the last character. Options include bold, italics, underscore, numeric options, and more.

Open format menu
Ctrl 1
⌘ 1
Toggle bold formatting
Ctrl B
⌘ B
Toggle italics formatting
Ctrl I
⌘ I
Toggle underscore formatting
Ctrl U
⌘ U
Toggle strikethrough formatting
Ctrl 5
⌘ Shift X
Left align the content of the cell
Alt H A L
⌘ L
Center align the content of the cell
Alt H A C
⌘ E
Right align the content of the cell
Alt H A R
⌘ R
Indent
Alt H 6
Control Option Tab
Undo indent
Alt H 5
Control Option Shift Tab
Increase font by one step size
Alt H F G
⌘ Shift >
Decrease font by one step size
Alt H F K
⌘ Shift <
Use scientific format
Ctrl Shift ^
Control Shift ^
Format cell value with currency formatting
Ctrl Shift $
Control Shift $
Format cell value with percentage formatting
Ctrl Shift %
Control Shift %
Format cell value with date formatting
Ctrl Shift #
Control Shift #
Format cell value with time formatting
Ctrl Shift @
Control Shift @
Format cell value with number formatting
Ctrl Shift !
Control Shift !
Format cell value with general formatting
Ctrl Shift ~
Control Shift ~