Excel Shortcut: Select Visible Cells Only
About This Shortcut Select Visible Cells Only – ALT+; chooses the visible cells in the current selection. Keybord Shortcut key Window: Alt +( ; ) Mac: Cmd + Shift + Z Example:
Excel Shortcut: Select all Dependents
About This Shortcut Select All Dependents – CTRL+SHIFT+} lets you pick cells with formulas that either directly or indirectly refer to the active cell. Keybord Shortcut key Window: Ctrl + Shift + } Mac: Ctrl + Shift + } Example:
Excel Shortcut: Select Direct Dependents
About This Shortcut Select Direct Dependents – It chooses the cells where the formulas directly refer to the active cells. Keybord Shortcut key Window: Ctrl + ] Mac: Ctrl + ] Example:
Excel Shortcut: Select all Precedents
About This Shortcut Select All Precedents – When you press CTRL + Shift+ {, you can choose direct or indirect predecessors of the current cell. Keybord Shortcut key Window: Ctrl + Shift + { Mac: Ctrl + Shift + { Example:
Excel Shortcut: Select Direct Precedents
About This Shortcut Select Direct Precedents – CTRL+ [ selects all the cells in the selection that are directly referred to by formulas. Keybord Shortcut key Window: Ctrl + [ Mac: Ctrl + [ Example:
Excel Shortcut: Select Current Region
About This Shortcut Select Current Region – The keyboard shortcut will select all of the cells on the worksheet, even the blank ones. Keybord Shortcut key Window: Ctrl + A Mac: Cmd + A Example:
Excel Shortcut: Select Current Region Around Active Cell
About This Shortcut Select Current Region Around Active Cell – Ctrl+ Shift + * lets you choose the area around the active cell. Keybord Shortcut key Window: Ctrl + Shift + ( * ) Mac: Ctrl + Shift + Space Example:
Excel Shortcut: Select Cells With Comments
About This Shortcut Select Cells With Comments – The shortcut key selects all cells that have comments in them. Keybord Shortcut key Window: Ctrl + Shift + O Mac: Fn + Ctrl + Shift + O Example:
Excel Shortcut: Display go to Dialog box
About This Shortcut Display ‘Go To’ Dialog box – You can use the F5 shortcut to quickly go to a certain cell in a worksheet. The keyboard shortcut brings up the Go To dialogue box, where you can enter the address of the desired cell. Keybord Shortcut key Window: Ctrl + G OR F5 Mac: …
Excel Shortcut: Toggle ‘Extend Selection’ Mode
About This Shortcut Toggle ‘Extend Selection’ Mode – The keyboard shortcut selects the formula bar from the current cursor location to the end of the bar. Keybord Shortcut key Window: F8 Mac: Fn + F8 Example:
