Shortcut Keys of Excel


Close a workbook                 Ctrl+W
Open a workbook                 Ctrl+O
Go to the Home tab            Alt+H
Save a workbook                  Ctrl+S
Copy                                      Ctrl+C
Paste                                      Ctrl+V
Undo                                     Ctrl+Z
Remove cell contents          Delete key
Choose a fill color                Alt+H, H
Cut                                         Ctrl+X
Go to Insert tab                   Alt+N
Bold                                       Ctrl+B
Center align cell contents    Alt+H, A, then C
Go to Page Layout tab        Alt+P
Go to Data tab                     Alt+A
Go to View tab                     Alt+W
Open context menu             Shift+F10, or
Context key
Add borders                         Alt+H, B
Delete column                      Alt+H,D, then C
Go to Formula tab               Alt+M
Hide the selected rows        Ctrl+9
Hide the selected columns  Ctrl+0




Shortcut Keys of MS Word

Ctrl+5                       1.5-line spacing.
Ctrl+E                      Aligns the line or selected text to the center of the screen.
Ctrl+L                      Aligns the line or selected text to the left of the screen.
Ctrl+R                      Aligns the line or selected text to the right of the screen.
Ctrl+J                       Aligns the selected text or line to justify the screen.
Ctrl+B                      Bold highlighted selection.
Ctrl+Shift+F            Change the font.
Shift+F3                   Change the text in different Cases.
Ctrl+Alt+1               Changes text to heading 1.
Ctrl+Alt+2               Changes text to heading 2.
Ctrl+Alt+3               Changes text to heading 3.
Ctrl+W                     Close the currently open document.
Ctrl+C                      Copy selected text.
Ctrl+T                      Create a hanging indent.
Shift+Enter              Create a soft break instead of a new paragraph.
Ctrl+X                      Cut selected text.
Ctrl+Shift+<            Decrease selected font by 2pt.
Ctrl+[                        Decrease selected font -1pts.
Ctrl+Shift+<            Decreases the selected text size by one font size.
Ctrl+Backspace       Deletes word to left of cursor.
Ctrl+Del                   Deletes word to right of cursor.
Ctrl+F2                    Display the print preview.
Ctrl+2                       Double-space lines.
Ctrl+Shift+>            Increase selected font +2pts.
Ctrl+]                        Increase selected font +1pts.
Ctrl+Shift+>            Increases the selected text size by one font size.
Ctrl+M                     Indent the paragraph.
Ctrl+/+c                    Insert a cent sign (¢).
Ctrl+'+<char>         Insert a character with an accent (grave) mark, (è) Ctrl+'+e
Ctrl+K                      Insert a hyperlink.
Shift+Alt+D             Insert the current date.
Shift+Alt+T             Insert the current time.
Ctrl+I                       Italic highlighted selection.
Ctrl+<left arrow>    Moves one word to the left.
Ctrl+<right arrow> Moves one word to the right.
Ctrl+Home               Moves the cursor to the beginning of the document.
Ctrl+End                  Moves the cursor to the end of the document.
Ctrl+<up arrow>    Moves to the beginning of the line or paragraph.
Ctrl+<down arrow>Moves to the end of the paragraph.
Ctrl+F                      Open find box.
F1                              Open Help.
Alt+Ctrl+F2             Open new document.
F5                              Open the Find, Replace, and Go To window in Microsoft Word.
Ctrl+P                      Open the print window.
Ctrl+D                      Open the font preferences window.
Ctrl+F1                    Open the Task Pane.
Ctrl+N                      Opens new, blank document window.
Ctrl+O                      Opens the dialog box or page for selecting a file to open.
Ctrl+V                      Paste.
Shift+Insert              Paste.
Ctrl+Shift+F12        Prints the document.
Ctrl+Shift+L            Quickly create a bullet point.
Ctrl+Y                      Redo the last action performed.
F4                              Repeat the last action performed (Word 2000+)
Ctrl+Spacebar         Reset highlighted text to the default font.
Shift+F7                   Runs a Thesaurus check on the selected word.
F12                            Save As.
Shift+F12                 Save the open document. Just like Ctrl+S.
Ctrl+S                       Save the open document. Just like Shift+F12.
Ctrl+A                      Select all contents of the page.
Ctrl+1                       Single-space lines.
F7                              Spellcheck and grammar check selected text or document.
Ctrl+Shift+F6          Switches to another open Microsoft Word document.
Ctrl+0                       Toggles 6pts of spacing before a paragraph.
Ctrl+U                      Underline the selected text.
Ctrl+Z                      Undo last action.
Ctrl+Shift+*            View or hide non printing characters.




Comments

Popular posts from this blog

HKC new post