10 shortcuts keys / Key combinations that suits for both Word and Excel, give quick access and helps to work faster :Their is availability of on-screen menus in Word and Excel, but the below shortcut key helps to work faster.
1. Undo and RedoBecause we all make a lot of typos and errors while working, the first ones on this list have to be Undo and Redo: Ctrl+Z and Ctrl+Y.2. Find & ReplaceCorrections are made easier with Find (Ctrl+F) and Replace (Ctrl+H). Ribbon shortcuts are Alt+H-F-D-F
3. Cut, Copy, PasteYou can copy and paste a paragraph using the original shortcut keys:Ctrl+C for copy, Ctrl+X for Cut and then Ctrl+V for paste.
4. Select or Select AllAnother shortcut that’s often used with Cut, Copy, Paste is Ctrl+A, which means Select All: That is, select the entire document, spreadsheet, or file.
In Word, place your cursor on any word and click twice to highlight/select that word. Click three times to select the entire paragraph.
In Excel, place your cursor on any cell and click twice to edit the cell contents.
5. Print and Print PreviewPrint is simple, but many users go straight to Print Preview as a final sanity check on margins and layout.
For Print, it’s Ctrl+P or Ctrl+Shift-F12.Print Preview is Ctrl+F2.6. GoToCtrl+G or F5, followed by a dialog box that opens for additional input—the
The GoTo feature can take you to a specific cell address or specific page. Click to view full image.
7. HomeIn Word, Home moves the cursor to the beginning of the line or row of your cursor’s current location. For example, if your cursor is on the ninth word of the third line, Home moves the cursor to the beginning of that line. Ctrl+Home moves the cursor to the Home position—that is, the beginning of the document.
In Excel, Home moves the cursor at the current cell address (e.g., K19) to the beginning of that line or row. It also moves the cursor to the beginning of a line or formula inside a cell while in Edit Mode. Ctrl+Home moves the cursor to cell A1.
8. CtrlIn Word, Ctrl+Right Arrow moves the cursor across the document one word and/or punctuation mark at a time.
Ctrl+Left Arrow does the same from right to left. Ctrl+Down Arrow moves the cursor down one carriage return/line break at a time.
Ctrl+Up Arrow does the same from bottom to top.
Ctrl+Page Down and Ctrl+Page Up move the cursor up and down one page at a time.
In Excel, Ctrl+Arrow key performs the same function as the End-Arrow keys.
Ctrl+Page Up and Ctrl+Page Down move through the tabs (additional inserted worksheets) one at a time:
Page Up for left-to-right
Page Down for right-to-left.
9. ShiftIn Word, Shift+End highlights from the cursor position to the end of the line
Shift+Home highlights to the beginning of the line.
Shift+End+Down Arrow extends the highlight to the next line
keep pressing Down Arrow to extend the highlight line by line.
Shift+Home+Up Arrow does the same in reverse, going to the beginning of the line and up.
Shift+Page Up and Shift+Page Down move the cursor up and down one screen at a time (about one third of a page).
In Excel, Shift+End+Down Arrow and Shift+End+Up Arrow highlight from the cursor position down or up to the end or beginning of the matrix/range row.
Shift+End+Right Arrow and Shift+End+Left Arrow highlight from the cursor position right or left to the end or beginning of the matrix/range column.
Shift+Home highlights from the cursor position to the beginning of any row (with or without data).
10. EndIn Word, the End key moves the cursor to the end of a line.
Ctrl+End moves the cursor to the end of a document, which includes any additional line or page breaks, tabs, spaces, etc.
In Excel, End has broader responsibilities. When you’re in Edit Mode, it moves the cursor to the end of a line only inside a text or formula cell. For the overall spreadsheet, the End key works with the cursor keys to determine direction.
End plus any arrow key moves the cursor to the last occupied cell in a column or row of data just before a blank, empty cell. For example, if the cursor is in A1 and the entire column contains empty cells, End-Down Arrow moves the cursor to the bottom of the entire workbook. The same rule applies horizontally: If an entire row is full of blank cells, your cursor is located at A1, and you select End-Right Arrow, the cursor moves to column XFD, row 1. (Note: End-Down Arrow is a combination keystroke executed in sequence, not a simultaneous keystroke like Ctrl+End).
Consider a grid of data that occupies cells A1 thru G11. Regardless of the current cursor position, when you press Ctrl+End, the cursor moves to the last, bottom, right cell of the matrix—in this case, G11. If, however, you’ve formatted your cells outside of the original matrix or have anything (even a space or a comma) in any cell outside the matrix range, Ctrl+End will move to the cell at the end of the last column and row that contains any data or formatting.
1. Undo and RedoBecause we all make a lot of typos and errors while working, the first ones on this list have to be Undo and Redo: Ctrl+Z and Ctrl+Y.2. Find & ReplaceCorrections are made easier with Find (Ctrl+F) and Replace (Ctrl+H). Ribbon shortcuts are Alt+H-F-D-F
3. Cut, Copy, PasteYou can copy and paste a paragraph using the original shortcut keys:Ctrl+C for copy, Ctrl+X for Cut and then Ctrl+V for paste.
4. Select or Select AllAnother shortcut that’s often used with Cut, Copy, Paste is Ctrl+A, which means Select All: That is, select the entire document, spreadsheet, or file.
In Word, place your cursor on any word and click twice to highlight/select that word. Click three times to select the entire paragraph.
In Excel, place your cursor on any cell and click twice to edit the cell contents.
5. Print and Print PreviewPrint is simple, but many users go straight to Print Preview as a final sanity check on margins and layout.
For Print, it’s Ctrl+P or Ctrl+Shift-F12.Print Preview is Ctrl+F2.6. GoToCtrl+G or F5, followed by a dialog box that opens for additional input—the
The GoTo feature can take you to a specific cell address or specific page. Click to view full image.
7. HomeIn Word, Home moves the cursor to the beginning of the line or row of your cursor’s current location. For example, if your cursor is on the ninth word of the third line, Home moves the cursor to the beginning of that line. Ctrl+Home moves the cursor to the Home position—that is, the beginning of the document.
In Excel, Home moves the cursor at the current cell address (e.g., K19) to the beginning of that line or row. It also moves the cursor to the beginning of a line or formula inside a cell while in Edit Mode. Ctrl+Home moves the cursor to cell A1.
8. CtrlIn Word, Ctrl+Right Arrow moves the cursor across the document one word and/or punctuation mark at a time.
Ctrl+Left Arrow does the same from right to left. Ctrl+Down Arrow moves the cursor down one carriage return/line break at a time.
Ctrl+Up Arrow does the same from bottom to top.
Ctrl+Page Down and Ctrl+Page Up move the cursor up and down one page at a time.
In Excel, Ctrl+Arrow key performs the same function as the End-Arrow keys.
Ctrl+Page Up and Ctrl+Page Down move through the tabs (additional inserted worksheets) one at a time:
Page Up for left-to-right
Page Down for right-to-left.
9. ShiftIn Word, Shift+End highlights from the cursor position to the end of the line
Shift+Home highlights to the beginning of the line.
Shift+End+Down Arrow extends the highlight to the next line
keep pressing Down Arrow to extend the highlight line by line.
Shift+Home+Up Arrow does the same in reverse, going to the beginning of the line and up.
Shift+Page Up and Shift+Page Down move the cursor up and down one screen at a time (about one third of a page).
In Excel, Shift+End+Down Arrow and Shift+End+Up Arrow highlight from the cursor position down or up to the end or beginning of the matrix/range row.
Shift+End+Right Arrow and Shift+End+Left Arrow highlight from the cursor position right or left to the end or beginning of the matrix/range column.
Shift+Home highlights from the cursor position to the beginning of any row (with or without data).
10. EndIn Word, the End key moves the cursor to the end of a line.
Ctrl+End moves the cursor to the end of a document, which includes any additional line or page breaks, tabs, spaces, etc.
In Excel, End has broader responsibilities. When you’re in Edit Mode, it moves the cursor to the end of a line only inside a text or formula cell. For the overall spreadsheet, the End key works with the cursor keys to determine direction.
End plus any arrow key moves the cursor to the last occupied cell in a column or row of data just before a blank, empty cell. For example, if the cursor is in A1 and the entire column contains empty cells, End-Down Arrow moves the cursor to the bottom of the entire workbook. The same rule applies horizontally: If an entire row is full of blank cells, your cursor is located at A1, and you select End-Right Arrow, the cursor moves to column XFD, row 1. (Note: End-Down Arrow is a combination keystroke executed in sequence, not a simultaneous keystroke like Ctrl+End).
Consider a grid of data that occupies cells A1 thru G11. Regardless of the current cursor position, when you press Ctrl+End, the cursor moves to the last, bottom, right cell of the matrix—in this case, G11. If, however, you’ve formatted your cells outside of the original matrix or have anything (even a space or a comma) in any cell outside the matrix range, Ctrl+End will move to the cell at the end of the last column and row that contains any data or formatting.
Comments
Post a Comment