Saturday, August 19, 2017

Formatting Shortcut Keys in Excel 2010

Formatting Shortcut Keys

SHORTCUT_KEYS____
DESCRIPTION______________________________________
Ctrl + B
Apply bold formatting on selected contents
Ctrl + I
Apply italic formatting on selected contents
Ctrl + U
Apply underline formatting on selected contents
Ctrl + 5
Apply/remove strike-through formatting on selected contents
Ctrl + 1
Open Format Cells dialog box
Alt  + ‘
Open Style dialog box
Ctrl + Shft + ~
Apply General Format on selected range
Ctrl + Shft + $
Apply Currency format on selected range
Ctrl + Shft + %
Apply Percentage format on selected range (#,###%)
Ctrl + Shft + #
Apply Date format on selected range (dd-mmm-yy)
Ctrl + Shft + @
Apply Time format on selected range (h:mm:ss AM/PM)
Ctrl + Shft + !
Apply Number format on selected range (#,###.00)
Ctrl + Shft + &
Apply outline-border on selected range
Ctrl + Shft + _
Remove cell borders from selected range
Alt + H + B + A
Apply cell border to all selected cells.



for more information, check below link:


No comments:

Post a Comment