My Favorite Excel Shortcuts

Here are some of my favorite keyboard shortcuts in Excel.

ALT + EnterWhen you are in a cell, this will add a new line
ALT + =SUM() formula
CTRL + FFind text on worksheet
CTRL + HFind text, and replace with something
CTRL + BFormat bold
CTRL + IFormat italics
CTRL + UFormat underline
CTRL + `This shows formulas. Also to remove.
CTRL + Shift + $Format cell in currency format
CTRL + Shift + &Add borders to selected cells
CTRL + SpacebarSelects the whole column
CTRL + ;Inserts the current date in cell
CTRL + TABSwitch between open workbooks
F2Probably my most used shortcut. This is to edit a cell