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
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
No comments:
Post a Comment