Not so obvious MS-Excel shortcuts and formulas

Shortcut	Explaination
alt + enter	Introduce a line break
ctrl + enter	enter and stay in the same cell
ctrl + .	Move to corners of a selected list
Changing values without formula	Paste Special – use Add , Multiply etc
Seeing all Formulas	ctrl + `
Highlight formulas	Home Ribbon –> Find & Select –> Formula Cell with formula will be selected Fill color Other great options as well in Find & Selecct. Ex. To select constanst – GO TO –> Constant
Auditing formulas	Highlight the part of the formula and press F9 to evaluate it. Hit ESC to not change the formula
Auto Sum	alt + =