consumerguidepro-excel-keyboard-shortcuts

Use toggle absolute references fast (f4 / cmd+t) to speed up formula work, reduce errors, and keep your model consistent.

Use edit the active cell without the mouse (f2 / ctrl+u) to speed up formula work, reduce errors, and keep your model consistent.

Use insert a function faster (shift+f3) to speed up formula work, reduce errors, and keep your model consistent.

Use open function arguments while editing (ctrl+a) to speed up formula work, reduce errors, and keep your model consistent.

Use insert argument names in a function (ctrl+shift+a) to speed up formula work, reduce errors, and keep your model consistent.

Use autosum in one keystroke (alt+= / cmd+shift+t) to speed up formula work, reduce errors, and keep your model consistent.

Use show formulas instead of results (ctrl+`) to speed up formula work, reduce errors, and keep your model consistent.

Use recalculate formulas on demand (f9 / shift+f9) to speed up formula work, reduce errors, and keep your model consistent.

Use expand or collapse the formula bar (ctrl+shift+u) to speed up formula work, reduce errors, and keep your model consistent.

Use paste a defined name into a formula (f3) to speed up formula work, reduce errors, and keep your model consistent.

Use open name manager fast (ctrl+f3) to speed up formula work, reduce errors, and keep your model consistent.

Use define names from labels (ctrl+shift+f3) to speed up formula work, reduce errors, and keep your model consistent.

Popular Articles