Ms Word & MS Excel
CTRL Shortcut Keys | Word | Excel |
---|---|---|
Ctrl+A | Extends a selection to include the entire document. | Selects the entire worksheet. If the worksheet contains data, Ctrl+A selects the current region. |
Ctrl+B | Applies or removes bold formatting. | Applies or removes bold formatting. |
Ctrl+C | Copies selected text or graphics to the Office Clipboard. | Copies the selected cells. |
Ctrl+D | Open the Font dialog box to change the font. | Copies the value from the cell above the active cell into the cell or the Formula Bar. |
Ctrl+E | Switches a paragraph between centered and left-aligned. | Flash Fill - Automatically fills in values. |
Ctrl+F | Opens the Navigation task pane. (to search document). | Displays the Find and Replace dialog box, with the Find tab selected. |
Ctrl+G | Goes to a page, bookmark, footnote, table, comment, graphic, or other location. | Displays the Go To dialog box. |
Ctrl+H | Replaces text, specific formatting, and special items. | Displays the Find and Replace dialog box, with the Replace tab selected. |
Ctrl+I | Applies or removes italic formatting. | Applies or removes italic formatting. |
Ctrl+J | Switches a paragraph between justified and left-aligned. | - |
Ctrl+K | Inserts a hyperlink. | Creates a link to a Web page, a picture, an e-mail address, or a program. |
Ctrl+L | Left aligns a paragraph. | Displays the Create Table dialog box. |
Ctrl+M | Indents a paragraph from the left. | - |
Ctrl+N | Creates a new document. | Creates a new, blank workbook. |
Ctrl+O | Opens a document. | Displays the Open dialog box to open or find a file. |
Ctrl+P | Switches in or out of print preview. | Displays the Print dialog box. |
Ctrl+Q | Removes paragraph formatting. | - |
Ctrl+R | Right aligns a paragraph. | Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right. |
Ctrl+S | Save a document. | Saves the active file with its current file name, location, and file format. |
Ctrl+T | Creates a hanging indent. | Displays the Create Table dialog box. |
Ctrl+U | Applies or removes underlining. | Applies or removes underlining. |
Ctrl+V | Pastes item from clipboard and keeps text only. | Paste - Inserts the contents of the Clipboard at the insertion point and replaces any selection. |
Ctrl+W | Closes the active window. | Closes the selected workbook window. |
Ctrl+X | Cuts the selected text, graphics or object to the Office Clipboard. | Cuts the selected cells. |
Ctrl+Y | Redoes or repeats an action. | Redoes the last command or action, if possible (after it was undone) |
Ctrl+Z | Undoes an action. | Uses the Undo command to reverse the last command or to delete the last entry that you typed. |
Source from https://www.veodin.com Reference Word 2013 shortcut keys https://www.veodin.com/keyrocket/shortcut-database/word-2013-shortcuts/ Excel 2013 shortcut keys https://www.veodin.com/keyrocket/shortcut-database/excel-2013-shortcuts/
Comments
Post a Comment