Sunday, 18 September 2011

Shortcut Keys Of Microsoft Office Excel 2003, 2007 and 2010

0 comments

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 row

Leave a Reply

Followers