Many users find that using an external keyboard with keyboard shortcuts for Excel helps them work more efficiently. For users with mobility or vision disabilities, keyboard shortcuts can be easier than using the touchscreen and are an essential alternative to using a mouse. Show
Notes:
This article describes the keyboard shortcuts, function keys, and some other common shortcut keys in Excel for Windows. Notes:
In this topic
Frequently used shortcutsThis table lists the most frequently used shortcuts in Excel.
Top of Page Ribbon keyboard shortcutsThe 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. Use the Access keys for ribbon tabsTo 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 Work in the ribbon with the keyboard
Top of Page Keyboard shortcuts for navigating in cells
Top of Page Keyboard shortcuts for formatting cells
Top of Page Keyboard shortcuts in the Paste Special dialog box in Excel 2013In 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 Keyboard shortcuts for making selections and performing actions
Top of Page Keyboard shortcuts for working with data, functions, and the formula bar
Top of Page Keyboard shortcuts for refreshing external dataUse the following keys to refresh data from external data sources.
Top of Page Power Pivot keyboard shortcutsUse the following keyboard shortcuts with Power Pivot in Microsoft 365, Excel 2019, Excel 2016, and Excel 2013.
Top of Page Function keys
Top of Page Other useful shortcut keys
Top of Page See alsoExcel 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:
In this topic
Frequently used shortcutsThis table itemizes the most frequently used shortcuts in Excel for Mac.
Top of Page Shortcut conflictsSome 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. Change system preferences for keyboard shortcuts with the mouse
Top of Page Work in windows and dialog boxes
Top of Page Move and scroll in a sheet or workbook
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 Enter data on a sheet
Top of Page Work in cells or the Formula bar
Top of Page Format and edit data
Top of Page Select cells, columns, or rows
Top of Page Work with a selection
* 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 Use charts
Top of Page Sort, filter, and use PivotTable reports
Top of Page Outline data
Top of Page Use function key shortcutsExcel 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 Change function key preferences with the mouse
Drawing
Top of Page See alsoExcel 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:
In this topic
Navigate the worksheet
Top of Page Format and edit data
Top of Page Work in cells or the formula bar
Top of Page See alsoExcel 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:
In this topic
Navigate the worksheet
Top of Page Work with cells
Top of Page See alsoExcel 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:
In this article
Quick tips for using keyboard shortcuts with Excel for the web
Frequently used shortcutsThese are the most frequently used shortcuts for Excel for the web.
Top of Page Access keys: Shortcuts for using the ribbonExcel 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.
Go to the access keys for the ribbonTo go directly to a tab on the ribbon, press one of the following access keys:
Top of Page Work in the ribbon tabs and menusThe shortcuts in this table can save time when you work with the ribbon tabs and ribbon menus.
Top of Page Keyboard shortcuts for editing cellsTip: 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 Keyboard shortcuts for entering data
Top of Page Keyboard shortcuts for editing data within a cell
Top of Page Keyboard shortcuts for formatting cells
Top of Page Keyboard shortcuts for moving and scrolling within worksheets
Top of Page Keyboard shortcuts for working with objects
Top of Page Keyboard shortcuts for working with cells, rows, columns, and objects
Top of Page Keyboard shortcuts for moving within a selected range
Top of Page Keyboard shortcuts for calculating data
Top of Page Accessibility Shortcuts Menu (Alt+Shift+A)Access the common features quickly by using the following shortcuts:
Top of Page Control keyboard shortcuts in Excel for the web by overriding browser keyboard shortcutsExcel 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.
See alsoExcel help center Use a screen reader to explore and navigate Excel Basic tasks using a screen reader with Excel Screen reader support for Excel Technical support for customers with disabilitiesMicrosoft wants to provide the best possible experience for all our customers. If you have a disability or questions related to accessibility, please contact the Microsoft Disability Answer Desk for technical assistance. The Disability Answer Desk support team is trained in using many popular assistive technologies and can offer assistance in English, Spanish, French, and American Sign Language. Please go to the Microsoft Disability Answer Desk site to find out the contact details for your region. If you are a government, commercial, or enterprise user, please contact the enterprise Disability Answer Desk. What are the symbols with which you specify the type of calculation that you want to perform on the elements of a formula?The symbols +, -, *, /, %, and ^ used to denote addition, subtraction (or negation), multiplication, division, percentage, and exponentiation in an Excel formula. An Excel feature that generates and extends values into adjacent cells based on the values of selected cells.
What are the symbols with which you can specify the type of calculation you want to perform in an Excel formula?Mathematical operators
Excel uses standard operators for formulas, such as a plus sign for addition (+), a minus sign for subtraction (-), an asterisk for multiplication (*), a forward slash for division (/), and a caret (^) for exponents.
What is an Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column is?Change the column width to automatically fit the contents (AutoFit) Select the column or columns that you want to change. On the Home tab, in the Cells group, click Format. Under Cell Size, click AutoFit Column Width.
What is the name of the area at the bottom of the Excel screen that shows the zoom level?The Status Bar can be set to show summary statistics based on any range of numerical values selected in your workbook. Read this post to find out How To Enable Status Bar Summary Statistics. What is this? Here you can select from three different worksheet views.
|