About This Shortcut Toggle Absolute and Relative References (in Cell Edit Mode) – This shortcut allows you to switch between absolute and relative references when entering or editing a formula in a cell. Keybord Shortcut key Window: F4 Mac: Cmd + T Example
Excel Shortcut: Toggle Absolute and Relative References Read Post »
About This Shortcut Open the Insert Function Dialog Box – This shortcut opens the Insert Function dialog box, which allows you to search for and insert a function into a cell. Keybord Shortcut key Window: Shift + F3 Mac: Fn + Shift + F3 Example
Excel Shortcut: Open the Insert Function Dialog Box Read Post »
About This Shortcut Autosum – This shortcut inserts the SUM function and automatically selects the range of cells adjacent to the active cell, providing a quick way to add up a range of numbers. Keybord Shortcut key Window: Alt + = Mac: Cmd + Shift + T Example
Excel Shortcut: Autosum Read Post »
About This Shortcut Toggle Displaying Formulas on and off – This shortcut toggles the display of formulas instead of their results in the worksheet, which can be useful for checking and debugging complex formulas. Keybord Shortcut key Window: Ctrl + ( ` ) Mac: Ctrl + ( ` ) Example
Excel Shortcut: Toggle Displaying Formulas on and off Read Post »
About This Shortcut Insert Function Arguments – This shortcut displays the function arguments dialog box, allowing you to enter or edit arguments for a function in a formula. Keybord Shortcut key Window: Ctrl + Shift + A Mac: Ctrl + Shift + A Example
Excel Shortcut: Insert Function Arguments Read Post »
About This Shortcut Align Center – This shortcut aligns the selected cells to the center horizontally. Keybord Shortcut key Window: Alt + H, A C Mac: Cmd + E Example
Excel Shortcut: Align Center Read Post »
About This Shortcut Apply or Remove Strikethrough – This shortcut applies or removes strikethrough formatting to the selected text or cells. Keybord Shortcut key Window: Ctrl + 5 Example
Excel Shortcut: Apply or Remove Strikethrough Read Post »
About This Shortcut Apply or Remove Underscore – This shortcut applies or removes underline formatting to the selected text or cells. Keybord Shortcut key Window: Ctrl + U Mac: Cmd + U Example
Excel Shortcut: Apply or Remove Underscore Read Post »
About This Shortcut Apply or Remove Italics – This shortcut applies or removes italics formatting to the selected text or cells. Keybord Shortcut key Window: Ctrl + I Mac: Cmd + I Example
Excel Shortcut: Apply or Remove Italics Read Post »
About This Shortcut Apply or Remove Bold – This shortcut applies or removes bold formatting to the selected text or cells. Keybord Shortcut key Window: Ctrl + B Mac: Cmd + B
Excel Shortcut: Apply or Remove Bold Read Post »