Free Excel Tips & Tricks

Subscribe to Get Daily Excel Tips & Tricks to your Inbox for Free!

Monday, July 23, 2018

EXECUTE EXCEL FORMULAS USING SHORTCUT KEYS

EXECUTE EXCEL FORMULAS USING SHORTCUT KEYS

=
Purpose:Use this excel shortcut key to Start/enter a formula

ALT +=
Purpose:Use this excel shortcut key to Insert the AutoSum formula.

CTRL +SHIFT +A
Purpose:Use this excel shortcut key to Insert Arguments in formula after typing formula name. .

SHIFT +F3
Purpose:Use this excel shortcut key to Insert a function into a formula. Display the Insert Function dialog box.

CTRL +SHIFT +ENTER
Purpose:Use this excel shortcut key to Enter a formula as an array formula.

F4
Purpose:Use this excel shortcut key to After typing cell reference (e.g. =E3) makes reference absolute (=$E$4)

F9
Purpose:Use this excel shortcut key to Calculate all worksheets in all open workbooks.

SHIFT +F9
Purpose:Use this excel shortcut key to Calculate the active worksheet.

CTRL +ALT +F9
Purpose:Use this excel shortcut key to Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.

CTRL +ALT +SHIFT +F9
Purpose:Use this excel shortcut key to Recheck dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.

CTRL +SHIFT +U
Purpose:Use this excel shortcut key to Toggle expand or collapse formula bar.

CTRL +`
Purpose:Use this excel shortcut key to Toggle Show formula in cell instead of values

No comments:

Post a Comment

EDITING CELLS USING EXCEL SHORTCUT KEYS

F2 Purpose: Use this excel shortcut key to Edit the active cell with cursor at end of the line. ALT +ENTER Purpose: Use this exc...