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
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
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
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
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
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
About This Shortcut Add Border Around Selected Cells – This shortcut adds a border around the selected cells. Keybord Shortcut key Window: Ctrl + Shift + & Example
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
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
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
