Excel Shortcuts for Formatting

Format Selection                Ctrl + 1

Apply or remove Bold formatting Ctrl + B

Apply or remove Italic formatting Ctrl + I

Apply or remove underscoring Ctrl + U

Apply or remove strikethrough formatting Ctrl + 5

Display Format Cells with Font tab selected Ctrl + Shift + F

Paste formats from selection ALT + EST

Format as Number with 2 dp        Ctrl + Shift + 1

Format as Time             Ctrl + Shift + 2

Format as Date             Ctrl + Shift + 3

Format as Currency              Ctrl + Shift + 4

Format as percentage with 0 dp     Ctrl + Shift + 5

Hide Row              Ctrl  + 9

Unhide Row          Ctrl + Shift + 9

Hide Column         Ctrl + 0

Single border around selected cells Ctrl + Shift + 7

Sort    Alt + DS

Filter    Ctrl + Shift + L

Insert hyperlink Ctrl + K

Freeze panes        ALT + WFF