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.
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.
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 365. 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.
Edit the active cell and put the insertion point at the end of its contents. Or, if editing is turned off for the cell, move the insertion point into the formula bar. If editing a formula, toggle Point mode off or on so you can use the arrow keys to create a reference.
F2 alone: edit the active cell and put the insertion point at the end of its contents. Or, if editing is turned off for the cell, move the insertion point into the formula bar. If editing a formula, toggle Point mode off or on so you can use the arrow keys to create a reference.
Left or Right arrow key selects the tab to the left or right when the ribbon is selected. When a submenu is open or selected, these arrow keys switch between the main menu and the submenu. When a ribbon tab is selected, these keys navigate the tab buttons.
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.
* 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.
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.
To find any command quickly, press Alt+Windows logo key, Q to jump to the Search or Tell Me text field. In Search or Tell Me, type a word or the name of a command you want (available only in Editing mode). Search or Tell Me searches for related options and provides a list. Use the Up and Down arrow keys to select a command, and then press Enter.
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.
There are keyboard shortcuts to accomplish a vast array of tasks in the Excel desktop client, in both the Windows and Mac versions. (Fewer shortcuts are available for the Mac, but you can create your own custom keyboard shortcuts if you like.)
This topic lists all keyboard shortcuts for the Microsoft 365 for Mac products. Keyboard shortcuts allow you to quickly complete commands and functions without using a mouse. The shortcuts in this topic refer to the US keyboard layout. Keys for other layouts might not correspond exactly to the keys on a US keyboard.
Within Excel you can conduct calculations on multiple worksheets and workbooks open at the same time. Each workbook acts as its own separate window on your PC or Mac, while each worksheet acts as a tab within a workbook with separate cells. This section of the Excel Guide offers all shortcuts you need to open, navigate between, and control all of these options.
Keyboard shortcuts aid accessibility and can make it easier and more efficient to navigate to different areas and elements on a page. They're supported by most web browsers, however, the behavior may vary slightly.
In addition to the global keyboard shortcuts described in this article, a number of business-specific shortcuts are available. For example, in the generic version of Business Central, F9 posts a document and Ctrl+F7 shows the ledger entries for a record when you open the record in a card. This article includes some of the more common business-specific shortcuts, which are shown in italics. Be aware that the actual shortcuts may be different in your solution. In the user interface, the keyboard shortcut is shown in the tooltip for the action in question.
The following table describes keyboard shortcuts for navigating and accessing different elements of a page. Elements include things like actions, drop-down lists, lookups, and more. For details about keyboard shortcuts for navigating records once you get inside a list, see the next section.
The following shortcuts pertain to the Quick Entry feature on cards, documents, and list pages. On lists, the shortcuts cannot be used when the list is in the tile view. For more information about Quick Entry, see Accelerating Data Entry Using Quick Entry.
When setting a date field, you can either enter the date manually or open a calendar (date picker) that lets you select the date you want. The following table describes the keyboard shortcuts for the calendar.
This post discusses learning and configuring shortcuts in Mac Excel.Learning shortcut keys in OSX applications is straight forward when the relevant key is displayed in the menu. However, some interface elements are not listed in menus.For general lists of Mac Excel shortcuts, see shortcutworld, and Microsoft.
This page contains a list of over 300+ Excel shortcuts for the Windows and Mac versions of Excel to speed up your work and productivity. Also, download a printable cheat sheet in PDF about keyboard shortcuts.
Before we take a deep dive into the topic, keep in mind the following rules. Excel shortcuts use two types of dividers: the comma sign (,) and the plus (+) sign. Just a few words about the differences:
If you are working with Excel, using the grid is essential. The following list contains the most useful Excel shortcuts regarding grid navigation. Select cells and ranges as soon as possible. Excel basic shortcuts like hiding and unhiding rows & columns boost your productivity.
Time is money: It can sometimes take a while to find the right button to click on in the right menu. This is why many users resort to keyboard shortcuts. You can also significantly speed up the work process in Excel using shortcuts for frequently used functions and inputs. We introduce you to the most useful Excel keyboard shortcuts and explain how you can create your own.
Every user has different priorities and different challenges to overcome. This makes it impossible to offer all the Excel shortcuts to please everyone. But the good news is that Microsoft enables you to create your own shortcuts. You need macros for this, which make it possible to record and save a sequence of steps. When the macro is executed afterwards, the same steps will be performed automatically by Excel. The practical thing about it is that you can assign macro shortcuts and activate them quickly.
Keyboard shortcuts for controlling office programs or the operating system are extremely popular. To learn more, see our articles on Mac shortcuts, Photoshop shortcuts, PowerPoint shortcuts, Windows shortcuts and Google Sheets shortcuts.
This post discusses learning and configuring shortcuts in Mac Excel. Learning shortcut keys in OSX applications is straight forward when the relevant key is displayed in the menu. However, some interface elements are not listed in menus. For general lists of Mac Excel shortcuts, see [shortcutworld]( _2011.html), and [Microsoft]( -us/excel/item/64766a97-9258-4f78-9feb-2742ce769041). I needed to look up the following shortcut keys: * Delete row or column: Highlight rows or columns and Ctrl + - * Insert cells: Ctrl + I This also works to insert columns and rows by first highlighting either columns (ctrl+space) or columns (shift+space) * Zoom in and zoom out; I just added the shortcut keys Cmd + = for zoom in and Cmd + - for zoom out. Admittedly this conflicts with calculate now, but Control + = also works for calculate now, and I rarely use spreadsheets that are so large that I need to delay computation. * Make Ctrl + left and Ctrl + Right be a synonym for Cmd + left and Cmd + Right; this works if the global shortcut key for moving between spaces is turned off or changed How to remove all formatting from cells: (1) Select cells (2) `Edit - Clear - Formats`. * Navigate to worksheet by name: In addition to Ctrl+Page Up/Page Down there is another option. Navigate to the `Go` dialog box and type the name of the sheet followed by `!a1` * Paste Special: Ctrl+Cmd+V opens the paste special dialog box then: Cmd+A is all, Cmd+V is values, Cmd+T is formats, Cmd+E is transpose. * F14 is equivalent to scroll lock on Windows. I occasionally accidentally press F14 when intending to press Home. The result is that the cursor keys annoyingly scroll the window rather than moving the focal cell. So it's good to know that F14 also de-activates scroll-lock. # Custo