Author name: Umesh Manral

About This Shortcut Enter Array Formula – This shortcut is used to enter an array formula into a cell, which allows you to perform calculations on multiple values at once. Keybord Shortcut key Window: Ctrl + Shift + Enter Mac: Ctrl + Shift + Retrun Example

About This Shortcut Calculate Worksheets – This shortcut calculates all open worksheets in the current workbook. Keybord Shortcut key Window: F9 Mac: Fn + F9 Example

About This Shortcut Calculate Active Worksheet – This shortcut calculates only the active worksheet in the current workbook. Keybord Shortcut key Window: Shift + F9 Mac: Fn + Shift + F9 Example

About This Shortcut Force Calculate all Worksheets – This shortcut recalculates all open worksheets in the current workbook, even if Excel has not detected any changes. Keybord Shortcut key Window: Ctrl + Alt + F9 Example

About This Shortcut Evaluate Part of a Formula (in Cell Edit Mode) – This shortcut allows you to evaluate part of a formula in the cell edit mode, which can be useful for checking and debugging complex formulas. Keybord Shortcut key Window: F9 Mac: Fn + F9 Example

About This Shortcut Expand or Collapse the Formula bar – This shortcut expands or collapses the formula bar, which can be useful when you want to see more or less of the formula in the formula bar. Keybord Shortcut key Window: Ctrl + Shift + U Mac: Ctrl + Shift + U Example

About This Shortcut Display Function Arguments Dialog box – This shortcut displays the function arguments dialog box for the selected function in a formula. Keybord Shortcut key Window: Ctrl + A Mac: Ctrl + A Example

About This Shortcut Open Name Manager – This shortcut opens the Name Manager, which allows you to manage named ranges and defined names in the current workbook. Keybord Shortcut key Window: Ctrl + F3 Mac: Fn + Ctrl + F3 Example

About This Shortcut Create name from values in row(s)/column(s) – This shortcut creates a new named range based on the values in the selected row(s) or column(s). Keybord Shortcut key Window: Ctrl + Shift + F3 Example

About This Shortcut Paste Name Into Formula – This shortcut pastes the name of a named range or defined name into a formula. Keybord Shortcut key Window: F3 Mac: F3 Example