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 + = |