Author name: Umesh Manral

About This Shortcut Delete Comment – Shift + F10 or M can be used to delete comments from an Excel spreadsheet. Keybord Shortcut key Window: Shift + F10, M Example:

About This Shortcut Insert or Edit Comment – It either puts a comment in a cell or adds one. Keybord Shortcut key Window: Shift + F2 Example:

About This Shortcut Edit the Active Cell – F2 puts the cursor at the end of the cell’s contents and starts “Edit mode.” Keybord Shortcut key Window: F2 Mac: Ctrl + U Example:

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:

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:

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:

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:

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:

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:

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: