Excel Formatting Shortcuts
Every Excel formatting shortcut in one place. Open any shortcut for Windows, Mac and Web keys, steps and alternatives.
Excel Formatting Keyboard Shortcuts
- Excel Bold shortcut
Makes the cell text bold.
Ctrl+BMac: Cmd + B - Excel Strikethrough shortcut
Crosses out the text in selected cells.
Ctrl+5Mac: Cmd + Shift + X - Excel Fill Color shortcut
Opens the fill colour menu for the selected cells.
Alt→H→H - Excel Merge and Center shortcut
Merges the selected cells and centers the text.
Alt→H→M→C - Excel Format Painter shortcut
Copies formatting from one cell to another.
Alt→H→F→P - Excel Wrap Text shortcut
Wraps long text onto several lines in the cell.
Alt→H→W - Excel Format Cells shortcut
Opens the Format Cells box.
Ctrl+1Mac: Cmd + 1 - Excel Clear Contents shortcut
Clears the contents of the selected cells.
DeleteMac: Delete - Excel Create Table shortcut
Turns the selected range into a table.
Ctrl+TMac: Cmd + T - Excel Insert Chart shortcut
Creates a chart from the selected data.
Alt+F1 - Excel Toggle Filters shortcut
Turns filter arrows on or off for the table.
Ctrl+Shift+LMac: Cmd + Shift + F - Excel Remove Duplicates shortcut
Deletes repeated rows from the selected range.
Data → Remove Duplicates - Excel Insert Comment shortcut
Adds a comment to the cell.
Ctrl+Shift+F2Mac: Cmd + Shift + F2