Knowing shortcuts can save a lot of time. below are few shortcut that can help one can save time while typing a huge document/report.
SHORTCUT KEY-COMBINATION FUNCTION
F1 Displays the current application’s Help window
CTRL + A Selects all text in current document
CTRL + B BOLD highlighted text
CTRL + I ITALICIZE highlighted text
CTRL + U UNDERLINE highlighted text
CTRL + L Left justifies current line or highlighted text
CTRL + R Right justifies current line or highlighted text
CTRL + E Center justifies current line or 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
ALT + E Opens the EDIT menu in the current application
ALT + F Opens the FILE menu in the current application
SHIFT + INS Pastes contents of Windows clipboard into current document
HOME Positions cursor at beginning of current line
CTRL + HOME Positions cursor at beginning of current document
END Positions cursor at end of current line
CTRL + END Positions cursor at end of current document
SHIFT + HOME Selects all text from current position to beginning of current line
SHIFT + END Selects all text from current position to end of current line
CTRL + LEFT ARROW Moves cursor to the left one word at a time
CTRL + RIGHT ARROW Moves cursor to the right one word at a time
SHORTCUT KEYS IN EXCEL
F27 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 + 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
12.934862
77.629124
Like this:
Be the first to like this post.