This article describes the keyboard shortcuts, function keys, and some other common shortcut keys in Excel for Windows. This table lists the most frequently used shortcuts in Excel.
Top of Page The ribbon groups related options on tabs. For example, on the Home tab, the Number group includes the Number Format option. Press the Alt key to display the ribbon shortcuts, called Key Tips, as letters in small images next to the tabs and options as shown in the image below.
You can combine the Key Tips letters with the Alt key to make shortcuts called Access Keys for the ribbon options. For example, press Alt+H to open the Home tab, and Alt+Q to move to the Tell me or Search field. Press Alt again to see KeyTips for the options for the selected tab. Depending on the version of Office you are using, the Search text field at the top of the app window might be called Tell Me instead. Both offer a largely similar experience, but some options and search results can vary. In Office 2013 and Office 2010, most of the old Alt key menu shortcuts still work, too. However, you need to know the full shortcut. For example, press Alt, and then press one of the old menu keys, for example, E (Edit), V (View), I (Insert), and so on. A notification pops up saying you're using an access key from an earlier version of Microsoft Office. If you know the entire key sequence, go ahead, and use it. If you don't know the sequence, press Esc and use Key Tips instead. To go directly to a tab on the ribbon, press one of the following access keys. Additional tabs might appear depending on your selection in the worksheet.
Top of Page
Top of Page
Top of Page In Excel 2013, you can paste a specific aspect of the copied data like its formatting or value using the Paste Special options. After you’ve copied the data, press Ctrl+Alt+V, or Alt+E+S to open the Paste Special dialog box.
Tip: You can also select Home > Paste > Paste Special. To pick an option in the dialog box, press the underlined letter for that option. For example, press the letter C to pick the Comments option.
Top of Page
Top of Page
Top of Page Use the following keys to refresh data from external data sources.
Top of Page Use the following keyboard shortcuts with Power Pivot in Microsoft 365, Excel 2019, Excel 2016, and Excel 2013.
Top of Page
Top of Page
Top of Page Excel help center Basic tasks using a screen reader with Excel Use a screen reader to explore and navigate Excel Accessibility support for Excel
This article describes the keyboard shortcuts, function keys, and some other common shortcut keys in Excel for Mac.
Notes:
This table itemizes the most frequently used shortcuts in Excel for Mac.
Top of Page Some Windows keyboard shortcuts conflict with the corresponding default macOS keyboard shortcuts. This topic flags such shortcuts with an asterisk (*). To use these shortcuts, you might have to change your Mac keyboard settings to change the Show Desktop shortcut for the key.
Top of Page
Top of Page
Tip: To use the arrow keys to move between cells in Excel for Mac 2011, you must turn Scroll Lock off. To toggle Scroll Lock off or on, press Shift+F14. Depending on the type of your keyboard, you might need to use the Control, Option, or the Command key instead of the Shift key. If you are using a MacBook, you might need to plug in a USB keyboard to use the F14 key combination. Top of Page
Top of Page
Top of Page
Top of Page
Top of Page
* These shortcuts might move in another direction other than down or up. If you'd like to change the direction of these shortcuts using the mouse, select Excel > Preferences > Edit, and then, in After pressing Return, move selection, select the direction you want to move to. Top of Page
Top of Page
Top of Page
Top of Page Excel for Mac uses the function keys for common commands, including Copy and Paste. For quick access to these shortcuts, you can change your Apple system preferences, so you don't have to press the Fn key every time you use a function key shortcut.
Note: Changing system function key preferences affects how the function keys work for your Mac, not just Excel for Mac. After changing this setting, you can still perform the special features printed on a function key. Just press the Fn key. For example, to use the F12 key to change your volume, you would press Fn+F12. If a function key doesn't work as you expect it to, press the Fn key in addition to the function key. If you don't want to press the Fn key each time, you can change your Apple system preferences. For instructions, go to Change function key preferences with the mouse. The following table provides the function key shortcuts for Excel for Mac.
Top of Page
Top of Page Excel help center Use a screen reader to explore and navigate Excel Basic tasks using a screen reader with Excel Screen reader support for Excel
This article describes the keyboard shortcuts in Excel for iOS.
Notes:
Top of Page
Top of Page
Top of Page Excel help & learning Screen reader support for Excel Basic tasks using a screen reader with Excel Use a screen reader to explore and navigate Excel
This article describes the keyboard shortcuts in Excel for Android.
Notes:
Top of Page Excel help & learning Screen reader support for Excel Basic tasks using a screen reader with Excel Use a screen reader to explore and navigate Excel
This article describes the keyboard shortcuts in Excel for the web.
Notes:
These are the most frequently used shortcuts for Excel for the web.
Top of Page Excel for the web offers access keys, keyboard shortcuts to navigate the ribbon. If you’ve used access keys to save time on Excel for desktop computers, you’ll find access keys very similar in Excel for the web. In Excel for the web, access keys all start with Alt+Windows logo key, then add a letter for the ribbon tab. For example, to go to the Review tab, press Alt+Windows logo key, R. If you're using Excel for the web on a Mac computer, press Control+Option to start.
To go directly to a tab on the ribbon, press one of the following access keys:
Top of Page The shortcuts in this table can save time when you work with the ribbon tabs and ribbon menus.
Top of Page
Tip: If a spreadsheet opens in the Viewing mode, editing commands won’t work. To switch to Editing mode, press Alt+Windows logo key, Z, M, E.
Top of Page
Top of Page
Top of Page
Top of Page
Top of Page
Top of Page
Top of Page
Top of Page
Top of Page Access the common features quickly by using the following shortcuts:
Top of Page Excel for the web works in a browser. Browsers have keyboard shortcuts, some of which conflict with shortcuts that work in Excel on the desktop. You can control these shortcuts, so they work the same in both versions of Excel by changing the Keyboard Shortcuts settings. Overriding browser shortcuts also enables you to open the Excel for the web Help by pressing F1.
Excel help center Use a screen reader to explore and navigate Excel Basic tasks using a screen reader with Excel Screen reader support for Excel |