basic keyboard shortcut

Ok sebagai permulaan, untuk warming-up. Kita akan mulakan dengan keyboard shortcut in MS Excel.

File

1. Open File = Ctrl + O
2. New File = Ctrl + N
3. Save File = Ctrl + S
4. Print = Ctrl + P

Format Cells

1. Format Cell option = Ctrl + 1
2. Wrap Text = Alt + Enter
3. Insert Cells = Ctrl + “+” (plus sign)
4. Delete Cells = Ctrl + “-” (minus sign)
5. Fill Down = Ctrl + D
6. Fill Right = Ctrl + R

Font

1. Bold = Ctrl + B
2. Italic = Ctrl + I
3. Underline = Ctrl + U

Column + Row

1. Select Column = Ctrl + Spacebar
2. Select Row = Shift + Spacebar
3. Insert Column & Row = Ctrl + “+” (plus sign)
4. Delete Column & Row = Ctrl + “-” (minus sign)

Calculation

1. Sum = Alt = “=” (equal sign)
2. Absolute / Anchoring ($) = F4 (press F4 to toggle the absolute position. make sure still in editing option)

Date & Time

1. Insert current date in particular cell = Ctrl ; 
2. Insert current time in particular cell = Ctrl Shift ;

Moving Around

1. Switch Between Program = Alt + Tab
2. Switch Between Sheet = Alt + Page Up/Down or Ctrl + Tab
3. Move to next change column/row = Ctrl / End + Arrow Key
4. Go to cell A1 = Ctrl + Home
5. Go to end of range = Ctrl + End
6. Hyperlink = Ctrl + K
7. Find = Ctrl + F
8. Replace = Ctrl + H
9. Go to cell = Ctrl + G

Misc

1. Undo = Ctrl + Z
2. Repeat = Ctrl + Y