Keyboard shortcuts in Excel for Windows
※ Download: Windows shortcut keys
ARROW KEYS Move one cell up, down, left, or right in a worksheet. SHIFT+F3 displays the Insert Function dialog box.
Other useful shortcuts Key Description Alt Displays the Key Tips new shortcuts on the Ribbon. They are typically an alternate means for invoking commands that would otherwise be accessible only through a menu, a mouse, or an aspect of the user interface. When a Ribbon tab is selected, these keys navigate the tab buttons. CTRL+SHIFT+F opens the Format Cells dialog box with the Font tab selected.
oops - ALT, W, I switches the worksheet to Page Break Preview view. Ctrl+Shift+Page Up Extend the selection of cells by one cell.
For example, to copy text, you can highlight text and press the Ctrl+C shortcut. The shortcut is faster than moving your hands from the keyboard, highlighting with the mouse, choosing copy from the file menu, and then returning to the keyboard. Below are the top 10 keyboard shortcuts we recommend everyone memorize and use. Ctrl+C or Ctrl+Insert and Ctrl+X Both Ctrl+C and Ctrl+ will copy text or a selected item. If you want to an item instead of copying it, press Ctrl+X. This action removes the text or item and stores it in the clipboard for you, rather than just it to the clipboard while leaving the original behind. For example, pressing Cmd+C copies highlighted text. Ctrl+V or Shift+Insert Both the Ctrl+V and Shift+Insert will the text or object that's stored in the. On Apple computers, use Cmd+V instead. Once Cut Move to the next field and press Ctrl+V or Shift+Insert to paste the text. For further demonstration, visit the following link. For example, if you cut text, pressing this key combination will undo the cut. These shortcuts can also be pressed multiple times to undo or redo multiple changes. Pressing Ctrl+Y would the undo. On Apple computers, use Cmd+Z and Cmd+Y to undo and redo. Use the above text input field to highlight some or all of the text and then press Ctrl+X to cut the text. Once the text has disappeared press the Ctrl+Z to undo the cut. Tip: If you did the first example as well cut and paste text and you continue to press Ctrl+Z, it is also going to undo that change. Ctrl+F Pressing Ctrl+F opens the field, which allows you to search the text currently displayed in any program that supports it. For example, Ctrl+F can be used in your Internet to find text on the current page. On Apple computers, use Cmd+F to find. Alt+Tab or Ctrl+Tab Pressing Alt+Tab switches between open programs moving forward. For example, if you have your browser window open and other programs running in the background press and hold Alt and then press the tab key to cycle through each open program. On Apple computers instead of using the Alt key use the Command Cmd key. For Example, Cmd+Tab to switch between open programs. Bonus Tip: Press Ctrl+Tab to switch between in a program. For example, if you have multiple tabs open in your Internet browser, press Ctrl+Tab to switch between them. Bonus Tip: Adding the to Alt+Tab or Ctrl+Tab moves backward. For example, if you are pressing Alt+Tab and pass the program you want to use, press Alt+Shift+Tab to move back to that program. Bonus Tip: Windows Vista, 7, 8, and 10 users can also press the + Tab to switch through open programs in a full screenshot of the window. Ctrl+Backspace and Ctrl+Left or Right arrow Note: The following shortcuts are for PC users only and do not work on Apple computers. Pressing Ctrl+ will delete a full word at a time instead of a single character. Holding down the Ctrl key while pressing the left or right arrow will move the cursor one word at a time instead of one character at a time. If you want to highlight one word at a time, hold down Ctrl+ Shift, then press the left or right arrow key. Your highlighted selection will move one word at a time in that direction. Here is example text to help demonstrate how you can delete multiple words at a time using Ctrl+Backspace. Click anywhere and then press Ctrl+Backspace to delete one word at a time instead of one character. Ctrl+S While working on a or other file in almost every program, pressing Ctrl+S that file. Use this shortcut key frequently if you're working on anything important in case an error happens, you lose power, or any other issues that could cause you to any work since the last save. On Apple computers, use Cmd+S to save a file. Ctrl+Home or Ctrl+End Ctrl+Home will move the cursor to the beginning of the document, and Ctrl+End will move the cursor to the end of a document. These shortcuts work with most documents, as well as web pages. On Apple computers use Command and the Cmd and the up arrow to get to the beginning of a document or text or Cmd and the down arrow to get to the end of a document or text. Ctrl+P Control+P is used to open a preview of the page or document currently being viewed. For example, press Ctrl+P now to view a print preview of this page. On Apple computers use Cmd+P to open the print preview. Page Up, Spacebar, and Page Down As you may have guessed, pressing either the or key will move to the next or previous page. When browsing the Internet, pressing the moves the down a page. Similarly, Shift+spacebar moves the scrollbar up one page.
Pressing Ctrl+Y would the undo. Ctrl+A Insert argument names and parentheses when the insertion point is to the right of a function name in a formula. Tip: Download or print a Quick Reference Card:. PRINT SCREEN CTRL+ALT+PLUS SIGN + Places a snapshot of the entire client windows area on the clipboard. Ctrl+Shift+Plus + Displays the Insert dialog box to insert blank cells. Window Snapping Shortcuts RELATED: Windows 10 offers improved support for Snap, known as.
