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 Apply General Format – This shortcut applies the default general format to the selected cells, which displays the values as plain numbers. Keybord Shortcut key Window: Ctrl + Shift + ( ~ ) Mac: Ctrl + Shift + ( ~ )
Excel Shortcut: Apply General Format Read Post »
About This Shortcut Apply Number Format – This shortcut applies the number format to the selected cells, which allows you to control the number of decimal places, separators, and other formatting options. Keybord Shortcut key Window: Ctrl + Shift + ! Mac: Ctrl + Shift + ! Example
Excel Shortcut: Apply Number Format Read Post »
About This Shortcut Apply Time Format – This shortcut applies the time format to the selected cells, which displays the values as time in the format of “hh:mm:ss”. Keybord Shortcut key Window: Ctrl + Shift + @ Mac: Ctrl + Shift + @ Example
Excel Shortcut: Apply Time Format Read Post »
About This Shortcut Apply Date Format – This shortcut applies the date format to the selected cells, which displays the values as dates in the format of “dd/mm/yyyy”. Keybord Shortcut key Window: Ctrl + Shift + # Mac: Ctrl + Shift + # Example
Excel Shortcut: Apply Date Format Read Post »
About This Shortcut Apply Currency Format – This shortcut applies the currency format to the selected cells, which displays the values as currency with the appropriate currency symbol. Keybord Shortcut key Window: Ctrl + Shift + $ Mac: Ctrl + Shift + $ Example
Excel Shortcut: Apply Currency Format Read Post »
About This Shortcut Apply Percentage Format – This shortcut applies the percentage format to the selected cells, which displays the values as a percentage with the % symbol. Keybord Shortcut key Window: Ctrl + Shift + % Mac: Ctrl + Shift + % Example
Excel Shortcut: Apply Percentage Format Read Post »
About This Shortcut Apply Scientific Format – This shortcut applies the scientific format to the selected cells, which displays the values in scientific notation with the appropriate number of decimal places. Keybord Shortcut key Window: Ctrl + Shift + ( ^ ) Mac: Ctrl + Shift + ( ^ ) Example
Excel Shortcut: Apply Scientific Format Read Post »
About This Shortcut Open List of Border Styles From Ribbon – This shortcut opens the list of border styles in the Ribbon, where you can choose from various border styles to apply to the selected cells. Keybord Shortcut key Window: Alt + H, B Example
Excel Shortcut: Open List of Border Styles From Ribbon Read Post »
About This Shortcut Add Border Around Selected Cells – This shortcut adds a border around the selected cells. Keybord Shortcut key Window: Ctrl + Shift + & Example
Excel Shortcut: Add Border Around Selected Cells Read Post »
About This Shortcut Add or Remove Right Border – This shortcut adds or removes a right border to the selected cells. Keybord Shortcut key Window: Alt + H, B R Mac: Cmd + Alt + → Example
Excel Shortcut: Add or Remove Right Border Read Post »