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 Add or Remove Left Border – This shortcut adds or removes a left border to the selected cells. Keybord Shortcut key Window: Alt + H, B L Mac: Cmd + Alt + ← Example
Excel Shortcut: Add or Remove Left Border Read Post »
About This Shortcut Add or Remove top Border – This shortcut adds or removes a top border to the selected cells. Keybord Shortcut key Window: Alt + H, B P Example
Excel Shortcut: Add or Remove top Border Read Post »
About This Shortcut Add or Remove Bottom Border – This shortcut adds or removes a bottom border to the selected cells. Keybord Shortcut key Window: Alt + H, B O Mac: Cmd + Alt + ↓ Example
Excel Shortcut: Add or Remove Bottom Border Read Post »
About This Shortcut Add all Borders to all Cells in Selection – This shortcut adds all borders to all cells in the selected range. Keybord Shortcut key Window: Alt + H, B A Example
Excel Shortcut: Add all Borders to all Cells in Selection Read Post »
About This Shortcut Remove Borders – This shortcut removes all borders from the selected cells. Keybord Shortcut key Window: Ctrl + Shift + – Mac: Cmd + Alt + – Example
Excel Shortcut: Remove Borders Read Post »
About This Shortcut Enter Array Formula – This shortcut is used to enter an array formula into a cell, which allows you to perform calculations on multiple values at once. Keybord Shortcut key Window: Ctrl + Shift + Enter Mac: Ctrl + Shift + Retrun Example
Excel Shortcut: Enter Array Formula Read Post »
About This Shortcut Calculate Worksheets – This shortcut calculates all open worksheets in the current workbook. Keybord Shortcut key Window: F9 Mac: Fn + F9 Example
Excel Shortcut: Calculate Worksheets Read Post »
About This Shortcut Calculate Active Worksheet – This shortcut calculates only the active worksheet in the current workbook. Keybord Shortcut key Window: Shift + F9 Mac: Fn + Shift + F9 Example
Excel Shortcut: Calculate Active Worksheet Read Post »
About This Shortcut Force Calculate all Worksheets – This shortcut recalculates all open worksheets in the current workbook, even if Excel has not detected any changes. Keybord Shortcut key Window: Ctrl + Alt + F9 Example
Excel Shortcut: Force Calculate all Worksheets Read Post »
About This Shortcut Evaluate Part of a Formula (in Cell Edit Mode) – This shortcut allows you to evaluate part of a formula in the cell edit mode, which can be useful for checking and debugging complex formulas. Keybord Shortcut key Window: F9 Mac: Fn + F9 Example
Excel Shortcut: Evaluate Part of a Formula Read Post »