Category Excel Shortcuts

Description and further info about Excel Keyboard shortcuts for windows and mac.

Toggle formulas on and off

Excel Shortcuts Toggle formulas on and off Displays or hides cell formulas instead of their results, making it easier to audit or debug your spreadsheet. Shortcut Windows Mac Toggle formulas on and off Ctrl` Ctrl` Relevant Excel Shortcuts Discover related…

Force calculate all worksheets

Excel Shortcuts Force calculate all worksheets Performs a full calculation on all open workbooks, including any cells Excel might otherwise skip, guaranteeing every formula is updated. Shortcut Windows Mac Force calculate all worksheets Ctrl Alt F9 Fn Ctrl Opt F9…

Calculate active worksheet

Excel Shortcuts Calculate active worksheet Only recalculates formulas in the currently active worksheet, letting you focus updates where you’re working without affecting other files. Shortcut Windows Mac Calculate active worksheet Shift F9 Fn Shift F9 Relevant Excel Shortcuts Discover related…

Calculate worksheets

Excel Shortcuts Calculate worksheets This shortcut recalculates all formulas in all open worksheets, ensuring every cell reflects the latest data. Shortcut Windows Mac Calculate worksheets F9 Fn F9 Relevant Excel Shortcuts Discover related Excel keyboard shortcuts in the formula calculations…

Enter array formula

Excel Shortcuts Enter array formula Enters or updates an array formula in selected cells, letting you handle advanced calculations that involve multiple ranges or outputs. Shortcut Windows Mac Enter array formula Ctrl Shift Enter Ctrl Shift Return Relevant Excel Shortcuts…

Autosum selected cells

Excel Shortcuts Autosum selected cells Automatically inserts the SUM function for selected cells, quickly totaling them without manually typing “=SUM()”. Shortcut Windows Mac Autosum selected cells Alt = Shift Cmd T Relevant Excel Shortcuts Discover related Excel keyboard shortcuts in…

Display Formula Builder dialog box

Excel Shortcuts Display Formula Builder dialog box Shows the Formula Builder dialog on Mac, allowing you to edit and assemble complex functions step by step. Shortcut Windows Mac Display Formula Builder dialog box Ctrl A Relevant Excel Shortcuts Discover related…

Display Function Arguments dialog box

Excel Shortcuts Display Function Arguments dialog box Brings up a dialog showing each parameter for the selected function, letting you fill them in without typing. Shortcut Windows Mac Display Function Arguments dialog box Ctrl A Ctrl A Relevant Excel Shortcuts…

Insert function arguments

Excel Shortcuts Insert function arguments Automatically inserts the placeholders for a chosen function’s arguments, saving you from manually typing them. Shortcut Windows Mac Insert function arguments Ctrl Shift A Ctrl Shift A Relevant Excel Shortcuts Discover related Excel keyboard shortcuts…

Open Formula builder

Excel Shortcuts Open Formula builder Opens the Formula Builder pane on Mac, helping you construct or edit formulas with an interface rather than manual typing. Shortcut Windows Mac Open Formula builder Fn Shift F3 Relevant Excel Shortcuts Discover related Excel…