Keyboard shortcuts for Microsoft Word on Windows
※ Download: Shortcut to save as in excel
F3 Paste a defined name into a formula. Keyboard shortcuts that begin with CTRL will still work in Excel 2010.
Ctrl+5 Switch between hiding objects, displaying objects, and displaying placeholders for objects. But movement is left and then to the above row.
Keyboard shortcuts in Excel for Windows - CTRL+S Saves the active file with its current file name, location, and file format. The list is based on Excel 2016, but most will also work on Excel 2013.
You may think you know all the Word and Excel keyboard shortcuts you need, but check this list first: These 10 will help everyone work faster. Shortcuts have evolved into an onscreen, menu-driven template with multiple options for each command in the program, also known as Ribbon shortcuts or access keys. But don't worry, the original simultaneous and combination shortcut keys are still available and working great! Please note that in this article, the letter 'F' followed by a number 1 through 12 refers to the function keys. Sartain Press the Alt key to access the Ribbon shortcuts. Commands also called key tip badges are displayed in black boxes. Click to view full image. The 5 essentials for Excel and Word No matter what you do, these shortcuts will serve you well. Undo and Redo Because 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. The Ribbon shortcuts are on the Quick Access Toolbar. Undo is depicted by an arrow curved to the left in both Word and Excel. Click to view full image. Ribbon shortcuts are Alt+H-F-D-F for Home, Find, Find in both Word and Excel. Replace in Word is Alt+H-R for Home, Replace. Cut, Copy, Paste You can copy and paste a paragraph using the original shortcut keys: Ctrl+C for copy or Ctrl+X for Cut , and then Ctrl+V for paste. The Ribbon shortcuts are Alt+H-C for Home, Copy or Alt+H-C-C for Home, Copy, Copy in Excel and Alt+H-X for Home, Cut in both Word and Excel. Note that Excel provides 14 additional Paste options and Word offers four. Sartain You can make faster work of Cut, Copy and Paste using the Ribbon shortcut keys. Click to view full image. But you don't have to go wild. Click three times to select the entire paragraph. In Excel, place your cursor on any cell and click twice to edit the cell contents. Print and Print Preview Print is simple, but many users go straight to Print Preview as a final sanity check on margins and layout. Print Preview is Ctrl+F2. The Ribbon version is Alt+F-P for both File, Print and Print Preview, because when you select Print, the Preview displays as well. Sartain You save constantly or you should , which is why you'll want to use these ribbon shortcuts for Save and Save As, plus Print and Print Preview. Click to view full image. Navigation shortcuts The bigger your document or spreadsheet is, the harder it is to move within it. These keyboard shortcuts make it easier to get where you need to go. GoTo The only Navigation command on the Ribbon menu is the GoTo feature, which means go to a specific cell address formula, object, region, etc. Sartain The GoTo feature can take you to a specific cell address or specific page. Click to view full image. 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. 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. Ctrl+Left Arrow does the same from right to left. 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, and Page Down for right-to-left. Note: End-Arrow is a combination keystroke executed in sequence, not a simultaneous keystroke like Ctrl+Arrow. Shift In Word, Shift+End highlights from the cursor position to the end of the line, and Shift+Home highlights to the beginning of the line. Shift+End+Down Arrow extends the highlight to the next line, and you can 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. Shift+Home highlights from the cursor position to the beginning of any row with or without data. End In 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. 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. Using Ctrl-End moves the cursor to G14. Click to view full image. In the example above, the grid has data in cells A1 through G11, but D14 has been formatted as a date. Therefore, Ctrl+End moves the cursor to the last row and column of the matrix that contains an active cell or G14. And that is the end. Did we miss anything that you couldn't live without? Let us know in the Comments. And stay tuned for more keyboard shortcuts, moving on to ones that are more obscure but amazingly handy.
Selects the first command on the menu when a menu or submenu is visible. Shortcuts have evolved into an onscreen, menu-driven template with multiple options for each command in the program, also known as Ribbon shortcuts or access keys. Alt+Ctrl+D Go to next footnote. 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. If more than one smart tag is present, it switches to the next smart tag and displays its menu or message. Ctrl+F9 Update linked information in a Microsoft Word source document. CTRL+X Cuts the selected cells. Ctrl+J Switch a paragraph between right-aligned and left-aligned. Ctrl+B Applies or removes bold formatting. Shift+arrow key Extend the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, to the next nonblank cell.
