Formatting Shortcuts

Number Formatting Use these shortcuts in Excel to apply number formats to a cell or cells in a range

Command	Windows Shortcuts	Mac Shortcuts
Format Painter	Alt, H, F, P
Apply general format	Ctrl + Shift + ~	Ctrl + Shift + ~
Apply currency format	Ctrl + Shift + $	Ctrl + Shift + $
Apply percentage format	Ctrl + Shift + %	Ctrl + Shift + %
Apply scientific format	Ctrl + Shift + ^	Ctrl + Shift + ^
Apply date format	Ctrl + Shift + #	Ctrl + Shift + #
Apply time format	Ctrl + Shift + @	Ctrl + Shift + @
Apply number format	Ctrl + Shift + !	Ctrl + Shift + !

 

Cell and Font Formatting

Here is the list of useful shortcuts regarding cell and font formatting. Locate the ribbon and choose the Home Tab and take a closer look at the functions.

Command	Windows Shortcuts	Mac Shortcuts
Format Window for cells and objects	Ctrl + 1	Cmd + 1
Display Format Cells with Font tab selected	Ctrl + Shift + F	Ctrl + Shift + F
Apply or remove bold formatting	Ctrl + B	Cmd + B
Apply or remove italic formatting	Ctrl + I	Cmd + I
Apply or remove underscoring	Ctrl + U	Cmd + U
Apply or remove strikethrough formatting	Ctrl + 5	Cmd + Shift + X
Add or remove the shadow font style	Cmd + Shift + W
Add or remove the outline font style	Cmd + Shift + D
Align center	Alt, H, A, C	Cmd + E
Align left	Alt, H, A, L	Cmd + L
Align right	Alt, H, A, R	Cmd + R
Align top	Alt, H, A, T
Align middle	Alt, H, A, M
Indent	Alt, H, 6	Ctrl+Alt+Tab
Remove indent	Alt, H, 5	Ctrl + Alt + Shift + Tab
Increase font size one step	Alt, H, F, G	Cmd + Shift + >
Decrease font size one step	Alt, H, F, K	Cmd + Shift + <
Wrap Text	Alt, H, W

 

Formatting Charts and Shapes

Command	Windows Shortcuts	Mac Shortcuts
Create a chart or PivotChart on the same worksheet	Alt + F1	Fn + Alt + F1
Create a chart in the new ChartSheet	F11	Fn + F11
Open Format Chart Area Task Pane	Ctrl +1	Cmd+1
Show or Hide All Field Buttons on PivotChart	Alt, J, T, D, A
Snap to Grid	Alt	Cmd +
Hide or show objects (shapes, charts, slicers)	Ctrl + 6	Ctrl + 6