Shortcut key Microsoft Excel 2003-2007

Definisi? Klik!

F12                 Edit contents of a cell

F7                  Spell check entire document or only highlighted text

F11                 Create chart

CTRL + ;            Enter the current date

CTRL + SHIFT + ;    Enter the current time

CTRL + ‘            Copies formula from cell above into current cell

CTRL + SHIFT + “    Copies value from cell above into current cell

CTRL + `            Toggles between displaying cell contents and cell formulas

CTRL + R            Copies contents of current cell into selected cells to the right

CTRL + D            Copies contents of current cell into selected cells below

ALT + SHIFT + F1    Create new worksheet

SHIFT + F3          Displays the formula dialogue

SHIFT + F5          Displays the search dialogue

CTRL + 1            Opens the Format Cells dialogue

CTRL + A            Selects all text in current document

CTRL + B            BOLD highlighted text

CTRL + I            ITALICIZE highlighted text

CTRL + U            UNDERLINE highlighted text

CTRL + 5            STRIKETHROUGH highlighted text

CTRL + X            Cuts (deletes) all highlighted text

CTRL + C            Copies all highlighted text to the Windows clipboard

CTRL + V            Pastes contents of Windows clipboard into current document at cursor position

CTRL + K            Insert hyperlink

CTRL + P            Displays the print dialogue

CTRL + Z            Undo last action

CTRL + Y            Repeat last action

CTRL + F6           Switches between open workbooks

CTRL + F9           Minimize current window

CTRL + F10          Maximize current window

CTRL + PGUP         Rotates forward between worksheets in current document

CTRL + PGDN         Rotates backward between worksheets in current document

CTRL + TAB             Rotates between open documents

CTRL + SHIFT + !       Displays numbers in comma format

CTRL + SHIFT + @       Displays numbers in time format

CTRL + SHIFT + #       Displays numbers in date format

CTRL + SHIFT + $       Displays numbers in currency format

CTRL + SHIFT + %       Displays numbers in percentage format

CTRL + SHIFT + ^       Displays numbers in scientific format

CTRL + SHIFT + ~       Displays numbers without special formatting

ALT + =                Adds a range of cells

CTRL + SHIFT + RIGHT ARROW     Positions cursor at next section of text

CTRL + SHIFT + LEFT ARROW      Positions cursor at previous section of text

CTRL + SPACE                   Selects entire current column

SHIFT + SPACE                  Selects entire current 

Sumber:http://www.mihirbabu.com/2011/09/shortcut-keys-of-microsoft-office-excel.html