วันอังคารที่ 11 พฤศจิกายน พ.ศ. 2557

Excel Short-cut

Alt + H + X = Cut
Alt + H + C = Copy
Alt + H + V = Paste
Alt + H + FO = Clipboard Option
Alt + H + FN = Font Option
Alt + H + FP = Format Painter
Alt + H + FF = Font Style
Alt + H + FS = Font Size
Alt + H + FG = Font Increase
Alt + H + FK = Font Decrease
Alt + H + 1 = Bold (Font)
Alt + H + 2 = Italic (Font)
Alt + H + 3 = Underline (Font)
Alt + H + B = Border Option
Alt + H + H = Highlight (Font)
Alt + H + FC = Font Color
Alt + H + FA = Alignment Option (Font)
Alt + H + AT = Top Alignment (Font)
Alt + H + AM = Middle Alignment (Font) Vertical
Alt + H + AB = Bottom Alignment (Font)
Alt + H + AL = Left Alignment (Font)
Alt + H + AC = Centre Alignment (Font) Horizontal
Alt + H + AR = Right Alignment (Font)
Alt + H + 5 = Left Indent
Alt + H + 6 = Right Indent
Alt + H + FQ = Font Orientation (Angular)
Alt + H + W = Wrap Text
Alt + H + M = Merge & Centre (multiple Cells with text)
Alt + H + FM = Number Format Option
Alt + H + N = Number Type option
Alt + H + AN = Currency Option
Alt + H + P = Percentage
Alt + H + K = Commas Format (number)
Alt + H + 0 = Increase Decimal (Zero)
Alt + H + 9 = Decrease Decimal
Alt + H + L = Conditional Formating
Alt + H + T = Table Formating
Alt + H + J = Cell Styles
Alt + H + I = Incert Cell
Alt + H + D = Delete Cell
Alt + H + O = Format Cell
Alt + H + U = Auto Sum
Alt + H + FI = Auto Fill
Alt + H + E = Clear Content
Alt + H + S = Sort & Filter
Alt + H + FD = Find & Select
After pressing Alt+H, you can see all these format

แหล่งที่มา   Facebook : Excel Tricks 

ไม่มีความคิดเห็น:

แสดงความคิดเห็น