Excel Shortcuts PC Mac
※ Download: Shortcut key to select all
Left Arrow key Excel keyboard shortcut reference Keyboard shortcuts for navigating in cells To do this Press Move to the previous cell in a worksheet or the previous option in a dialog box. Ctrl+Y Repeats the last command or action, if possible. Ctrl+Home Move one screen down in a worksheet.
Ctrl+3 Applies or removes italic formatting. Pressing Ctrl+Shift+Spacebar a second time selects the current region and its summary rows. Other useful shortcuts Note: Download or print a Quick Reference Card:.
Keyboard shortcuts in Excel for Windows - Ctrl+Alt+5, and then the Tab key repeatedly Exit the floating shape navigation and return to the normal navigation.
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.
A highlighted area shows you where the window will rest when you let go of the mouse button. Ctrl+Y Undo the last action. CTRL+T Displays the Create Table dialog box. CTRL+SHIFT+~ Applies the General number format. SHIFT+F11 inserts a new worksheet. In the same image above, you can see that some of the common features, such as Open Ctrl+O and Save Ctrl+Shave shortcut keys assigned to them. The Ribbon comes with new shortcuts, called Key Tips, which you can make appear when you press the Alt shortcut key to select all. Ctrl+U or Ctrl+4 Apply or remove strikethrough formatting. If the cursor is in the formula bar, Ctrl+Shift+End selects all text in the formula bar from the cursor position to the end—this does not affect the height of the formula bar.
