Microsoft Excel stores and analyses data worldwide. Excel is still the go-to data analytics tool despite newer tools. Its many features simplify data organization. Moreover, Excel shortcuts speed up data manipulation. Excel uses shortcuts, and Excel shortcut keys speed up our work and boost productivity. These shortcut keys work with most Windows versions of Excel.
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 Direct Dependents Read Post »
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 all Precedents Read Post »
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 Direct Precedents Read Post »
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 Read Post »
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 Current Region Around Active Cell Read Post »
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: Select Cells With Comments Read Post »
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: Display go to Dialog box Read Post »
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:
Excel Shortcut: Toggle ‘Extend Selection’ Mode Read Post »
About This Shortcut Cancel ‘Extend Selection’ Mode – The F8 key is useful to turn the extended selection mode on or off. Keybord Shortcut key Window: Esc Mac: Esc Example:
Excel Shortcut: Cancel ‘Extend Selection’ Mode Read Post »
About This Shortcut Extend Selection to Last Cell in Worksheet – It lets you choose a cell all the way back to the beginning of the worksheet. Keybord Shortcut key Window: Ctrl + Shift + End Mac: Fn + Ctrl + Shift + → Example:
Excel Shortcut: Extend Selection to Last Cell in Worksheet Read Post »