Many users uncover that utilizing an external keyboard with keyboard shortcuts for Excel helps them work much more efficiently. For users v mobility or vision disabilities, keyboard shortcuts can be less complicated than making use of the touchscreen, and also are critical alternative to using a mouse.
Notes:
The shortcuts in this topic refer to the US keyboard layout. Tricks for other layouts could not correspond specifically to the keys on a us keyboard.
You are watching: Which of the following keys moves the insertion point to the end of data in a cell
A plus sign (+) in a shortcut means that you need to press multiple tricks at the very same time.
A comma sign (,) in a shortcut way that you have to press multiple keys in order.
This write-up describes the keyboard shortcuts, role keys, and also some other common shortcut keys in Excel because that Windows.
Notes:
To quickly discover a shortcut in this article, you deserve to use the Search. Press Ctrl+F, and then type your search words.
In this topic
Ribbon key-board shortcuts
keyboard shortcuts because that formatting cells
Frequently offered shortcuts
This table perform the most generally used shortcuts in Excel.
| Close a workbook | Ctrl+W |
| Open a workbook | Ctrl+O |
| Go come the Home tab | Alt+H |
| Save a workbook | Ctrl+S |
| Copy | Ctrl+C |
| Paste | Ctrl+V |
| Undo | Ctrl+Z |
| Remove cell contents | Delete |
| Choose a fill color | Alt+H, H |
| Cut | Ctrl+X |
| Go come Insert tab | Alt+N |
| Bold | Ctrl+B |
| Center align cell contents | Alt+H, A, C |
| Go come Page Layout tab | Alt+P |
| Go to Data tab | Alt+A |
| Go come View tab | Alt+W |
| Open paper definition menu | Shift+F10, or Context key |
| Add borders | Alt+H, B |
| Delete column | Alt+H, D, C |
| Go come Formula tab | Alt+M |
| Hide the selected rows | Ctrl+9 |
| Hide the selected columns | Ctrl+0 |
optimal of web page
Ribbon key-board shortcuts
The ribbon groups related choices on tabs. For example, top top the Home tab, the Number group includes the Number Format option. Push the Alt key to display the ribbon shortcuts, called an essential Tips, as letters in tiny images alongside the tabs and alternatives as displayed in the image below.
You can incorporate the key Tips letters through the Alt an essential to do shortcuts called access Keys because that the ribbon options. Because that example, push Alt+H to open up the Home tab, and also Alt+Q to move to the Tell me or Search field. Press Alt again to watch KeyTips for the alternatives for the selected tab.
In Office 2013 and Office 2010, most of the old Alt key menu shortcuts quiet work, too. However, you require to know the full shortcut. For example, press Alt, and also then press among the old menu keys E (Edit), V (View), ns (Insert), and also so on. A notice pops up speak you"re making use of an access key from an earlier version that bsci-ch.org Office. If you know the entire vital sequence, walk ahead and use it. If friend don"t recognize the sequence, press Esc and also use vital Tips instead.
Use the accessibility keys because that ribbon tabs
To go directly to a tab ~ above the ribbon, press among the following access keys. Additional tabs may appear depending on your an option in the worksheet.
| Move to the Tell me or Search field on the Ribbon and kind a search term for aid or help content. | Alt+Q, then get in the find term. |
| Open the File page and use Backstage view. | Alt+F |
| Open the Home tab and also format text and numbers and use the discover tool. | Alt+H |
| Open the Insert tab and insert PivotTables, charts, add-ins, Sparklines, pictures, shapes, headers, or text boxes. | Alt+N |
| Open the Page Layout tab and work through themes, page setup, scale, and also alignment. | Alt+P |
| Open the Formulas tab and insert, trace, and also customize functions and also calculations. | Alt+M |
| Open the Data tab and also connect to, sort, filter, analyze, and also work through data. | Alt+A |
| Open the Review tab and check spelling, add notes and threaded comments, and protect sheets and also workbooks. | Alt+R |
| Open the View tab and also preview page breaks and also layouts, show and hide gridlines and headings, collection zoom magnification, manage windows and also panes, and view macros. | Alt+W |
peak of page
Work in the ribbon v the keyboard
| Select the energetic tab on the ribbon, and activate the access keys. | Alt or F10. To relocate to a different tab, use accessibility keys or the arrowhead keys. |
| Move the focus to commands on the ribbon. | Tab key or Shift+Tab |
| Move down, up, left, or right, respectively, amongst the items on the Ribbon. | Arrow keys |
| Activate a selected button. | Spacebar or Enter |
| Open the list for a selected command. | Down arrow key |
| Open the food selection for a selected button. | Alt+Down arrowhead key |
| When a food selection or submenu is open, relocate to the following command. | Down arrowhead key |
| Expand or please the ribbon. | Ctrl+F1 |
| Open a paper definition menu. | Shift+F10 Or, top top a home windows keyboard, the Context an essential (between the right Alt and also right Ctrl keys) |
| Move come the submenu when a main menu is open up or selected. | Left arrowhead key |
peak of page
Keyboard shortcuts for navigating in cells
| Move come the previous cabinet in a worksheet or the previous alternative in a dialog. | Shift+Tab |
| Move one cabinet up in a worksheet. | Up arrowhead key |
| Move one cell down in a worksheet. | Down arrow key |
| Move one cabinet left in a worksheet. | Left arrow key |
| Move one cell appropriate in a worksheet. | Right arrowhead key |
| Move come the sheet of the current data region in a worksheet. | Ctrl+Arrow key |
| Enter the end mode, relocate to the following nonblank cell in the same column or row as the active cell, and turn off end mode. If the cells room blank, relocate to the critical cell in the row or column. | End, arrow key |
| Move to the last cell top top a worksheet, come the lowest supplied row of the rightmost used column. | Ctrl+End |
| Extend the an option of cell to the last provided cell on the worksheet (lower-right corner). | Ctrl+Shift+End |
| Move come the cabinet in the upper-left edge of the window when scroll Lock is rotate on. | Home+Scroll Lock |
| Move come the start of a worksheet. | Ctrl+Home |
| Move one screen down in a worksheet. | Page Down |
| Move come the following sheet in a workbook. | Ctrl+Page Down |
| Move one display screen to the ideal in a worksheet. | Alt+Page Down |
| Move one display screen up in a worksheet. | Page Up |
| Move one display to the left in a worksheet. | Alt+Page Up |
| Move to the previous paper in a workbook. | Ctrl+Page Up |
| Move one cabinet to the best in a worksheet. Or, in a defended worksheet, move in between unlocked cells. | Tab key |
| Open the perform of validation options on a cabinet that has actually data validation option used to it. | Alt+Down arrow key |
| Cycle with floating shapes, together as text boxes or images. | Ctrl+Alt+5, climate the Tab vital repeatedly |
| Exit the floating shape navigation and return come the normal navigation. | Esc |
| Scroll horizontally. | Ctrl+Shift, then scroll your mouse wheel up to go left, down to walk right |
| Zoom in. | CTRL+ALT+= |
| Zoom out. | CTRL+ALT+- |
top of web page
Keyboard shortcuts because that formatting cells
| Open the format Cells dialog. | Ctrl+1 |
| Format fonts in the layout Cells dialog. | Ctrl+Shift+F or Ctrl+Shift+P |
| Edit the energetic cell and also put the insertion point at the finish of that contents. Or, if editing and enhancing is turned off for the cell, relocate the insertion point into the formula bar. If editing and enhancing a formula, toggle suggest mode off or on for this reason you have the right to use arrowhead keys to produce a reference. | F2 |
| Insert a note Open and edit a cell note | Shift+F2 Shift+F2 |
| Insert a threaded comment Open and also reply to a threaded comment | Ctrl+Shift+F2 Ctrl+Shift+F2 |
| Open the Insert dialog come insert empty cells. | Ctrl+Shift+Plus authorize (+) |
| Open the Delete dialog to delete selected cells. | Ctrl+Minus sign (-) |
| Enter the present time. | Ctrl+Shift+colon (:) |
| Enter the current date. | Ctrl+semi-colon (;) |
| Switch between displaying cell values or formulas in the worksheet. | Ctrl+grave accent (`) |
| Copy a formula native the cell above the active cell right into the cabinet or the Formula Bar. | Ctrl+apostrophe (") |
| Move the selected cells. | Ctrl+X |
| Copy the selected cells. | Ctrl+C |
| Paste content at the insertion point, replacing any selection. | Ctrl+V |
| Open the Paste distinct dialog. | Ctrl+Alt+V |
| Italicize text or eliminate italic formatting. | Ctrl+I or Ctrl+3 |
| Bold text or eliminate bold formatting. | Ctrl+B or Ctrl+2 |
| Underline text or eliminate underline. | Ctrl+U or Ctrl+4 |
| Apply or remove strikethrough formatting. | Ctrl+5 |
| Switch in between hiding objects, displaying objects, and displaying placeholders because that objects. | Ctrl+6 |
| Apply an overview border to the selected cells. | Ctrl+Shift+ampersand (&) |
| Remove the summary border from the selected cells. | Ctrl+Shift+underline (_) |
| Display or hide the overview symbols. | Ctrl+8 |
| Use the Fill down command to copy the contents and also format of the topmost cabinet of a selected selection into the cell below. | Ctrl+D |
| Apply the general number format. | Ctrl+Shift+tilde authorize (~) |
| Apply the currency format v two decimal locations (negative numbers in parentheses). |