Know Shortcut Keys in your PC

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

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s