time-saving Hotkeys for Excel exportable, wiki-style reference lists for Keyboard Shortcuts/Hotkeys. F10, Turns key tips on or off. SHIFT + ALT + Left Arrow. Group Rows/Columns. SHIFT + ALT + Right Arrow Ungroup Rows/Columns. Function Key Shortcuts. F2. Edit Cells. F4. Anchor Cells . Lists the most common and popular keyboard shortcuts. Excel Shortcuts and Hotkeys: The Power Spreadsheets Cheat Sheet Alt + JA, (1) In Excel and later, go to Format tab of the Ribbon (when active); or (2) In Excel and , go to . Alt, F10, Turn key tips (Ribbon keyboard shortcuts) On or Off, Alt is also.
|Language:||English, Spanish, Dutch|
|ePub File Size:||23.80 MB|
|PDF File Size:||16.12 MB|
|Distribution:||Free* [*Sign up for free]|
Microsoft Excel Keyboard Keys. Source: Key. Copying and Moving Text. Description. Shortcut Key. Cut. Ctrl + X. Copy. Ctrl + C List Cells With Comments. Excel / / +. Quick Reference – The Most Important Keyboard Shortcuts for. Finance (IB, PE, HF/AM, ER, CF, etc.) http://breakingintowallstreet. com. Microsoft Excel Keyboard Shortcuts Applies the General number format in Microsoft Excel. CTRL+Shift . CTRL+ARROW KEY moves to the edge of the.
For example: You may not see some of the tabs that are displayed above. This may be the case, for example, if you don't have the Developer tab enabled. You may see additional tabs. This may be the case, for example, if you have selected an object such as a chart and, as a consequence, Excel displays a contextual tab. For example, I took the following screenshot when a chart is selected.
Then you get to choose the letter at the end of the key combination.
That method is slow and difficult to perform. They will save you a lot of time. If you have ever recorded your own macro and assigned a shortcut key to it, you know that you lose the undo history when you press the shortcut key to run the macro.
This is not the case with the add-in. The full version of the Formatting Shortcuts add-in allows you to retain the full Undo History in Excel.
The screencast below shows an example of this. In this video I setup a shortcut key for a cell style that contains number formatting, borders, font, and fill colors. Finally, I undo my actions using the Undo button. Features Here are a few additional features of the add-in: Easy to Use — The shortcut keys and cell formatting can be changed with the click of a few buttons. This includes custom styles and all formatting options. This appears on the left side of the pane, just below the Choose commands from drop-down list.
You can add a commands to the Quick Access Toolbar in the following 2 steps: Step 1: Select the command you want in the Choose commands from drop-down list.
For example, in the following screenshot, I chose the Center command: Step 2: Click on the Add button in the center of the Excel Options dialog. As I explain above, the exact keyboard shortcut assigned to a particular command depends on its location in the Quick Access Toolbar.
Therefore, you can determine within a certain limited scope what is the keyboard shortcut for the commands you add to the Quick Access Toolbar by placing them in the appropriate position. Click on the appropriate arrow as many times as required in order to place the command in the position you desire. The resulting Quick Access Toolbar displays any new commands that you've added by following the process described above.
If you've completed the 5 steps above, you've created a custom Excel keyboard shortcut. Let's take a look at a practical example. In this particular case, I place the command in the first position of the Quick Access Toolbar. The following image shows how the Quick Access Toolbar looks like after the process above has been completed.
Notice how the newly added command appears at the beginning of the Quick Access Toolbar and is paired with the number 1. Dialog Box Keyboard Shortcuts For Excel: Hotkeys The information within the previous sections in this Excel tutorial allows you to execute a huge amount of commands. However, you'll soon notice that, in several cases, a particular keyboard shortcut leads you to a dialog box.
This section explains how you can use keyboard shortcuts to interact with most dialog boxes within Excel. As a general matter, you can use Hotkeys to interact with dialog boxes within Excel. I introduce Hotkeys at the beginning of this Excel tutorial. You can generally recognize Hotkeys within a particular dialog box because Excel underlines the corresponding letter.
Working with Hotkeys is quite straightforward and, to a certain extent, is similar to working with the Key Tips that help you with Ribbon and Quick Access Toolbar keyboard shortcuts.
Let's start by taking a look at a dialog box and its Hotkeys. The following screenshot shows the Format Cells dialog box, with the Alignment tab selected. The arrows point to some of the underlined letters within this dialog box. When you're working with a dialog box and face such a situation, you just need to remember the following: To select a command using keyboard shortcuts, press the relevant Hotkey. In some cases, you have to press the relevant Hotkey plus the Alt key.
Some of the cases in which you won't need to press the Alt key at the same time as the Hotkey are the following: If i the dialog box you're working with doesn't have tabs and ii the current selected option isn't a drop-down list or a spinner control. The Paste Special dialog box that I show at the beginning of this blog post doesn't have tabs, drop-down lists or spinner controls.
If the dialog box you're working with has tabs, but i the current selected option is within the tab in which the relevant Hotkey appears and ii that current selected option isn't a box or a spinner control. In other words, it isn't enough that the displayed tab is the one you want to work with. The current selected option must be one of the commands within the tab.
Even though it isn't required in these situations, you can anyway press the Alt key at the same time as the relevant Hotkey. The result generally doesn't change and Excel usually takes you to the same option as if you hadn't press the Alt key. You are, however, generally required to press the Alt key at the same time as the Hotkey if the conditions above aren't met. In other words, you generally press the Alt key when: The current selected option within a dialog box is a list box or spinner control.
The dialog box has tabs and the current selected option isn't within the tab in which the relevant Hotkey appears.
Knowing which is the current selected option may be a little bit tricky in some cases. In most cases, particularly if the current selection option is within the displayed tab, Excel shows a dotted square around the current selected option.
Compare the images above with the one below, where there are no dotted lines to be found. In this case, even though the Alignment tab is displayed, the current selected option isn't within the Alignment tab. The selected option is, actually, the Alignment tab itself.
In this case, the Hotkeys continue to be the same.
However, you must press the Alt key at the same time as the relevant Hotkey. The following image highlights some of these lists and spinners: When working within dialog boxes, you generally have to confirm your choice by pressing the Enter key. As I explain below, Enter is the equivalent of clicking on the default button of the dialog box. Usually, the default button of a dialog box is OK. However, you may eventually notice not all options within a Dialog Box have an underlined letter.
In fact, several of the dialog boxes I show within this Excel tutorial have at least 1 such option, where no letter is underlined. The lack of an underlined letter doesn't necessarily mean that you can't interact with such an option using your keyboard.
To see how this works, let's go back to the Excel Options dialog that I introduce above when explaining how to create custom keyboard shortcuts by customizing the Quick Access Toolbar: In order to customize the Quick Access Toolbar using the method I describe in this Excel tutorial, you access the Quick Access Toolbar tab of the Excel Options dialog.
The first 3 components of each of these keyboard shortcuts open the Excel Options dialog box. The letter F displays the Formulas tab. This same rules applies in other dialog boxes. Let's go back to the Alignment tab of the Format Cells dialog box that I use in the examples above. Notice that the tab labels don't have underlined letters: In such cases, as long as the current selected option isn't within the displayed tab, you can go to a particular tab by pressing the first letter of the label.
In other words: N displays the Number tab. F takes you to the Font tab. This is already quite specific, so you may be surprised that this still doesn't cover absolutely all of the possible options. You may eventually encounter the following situation: Dialog Box Keyboard Shortcuts: What Happens When There Are No Underlined Letters And 2 Options Begin With The Same Letter The rule for using keyboard shortcuts within a dialog box when there are no underlined letters as explained in the previous section is relatively simple: To choose an option, press the first letter of its label.
However, if 2 labels begin with the same letter, this rule doesn't work for all of those options. After all, the same key shouldn't lead to 2 different consequences.
To see how this can happen, let's go back once more to the left-side pane of the Excel Options dialog. Notice that 2 labels Advanced and Add-ins begin with the same letter A : In this case, the letter A works as a keyboard shortcut for the first tab Advanced. To go to the Add-ins tab, you actually need to press the first key of the label twice. Enters the current time. Available only after you have cut or copied an object, text, or cell contents. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program.
Smart-Art Graphics: Work with shapes Tab Select the next element in a SmartArt graphic. Esc Remove focus from the selected shape. Arrow Up Nudge the selected shape up. Arrow Down Nudge the selected shape down. Arrow Left Nudge the selected shape left. Arrow Right Nudge the selected shape right. Add ctrl for moving pixel-by-pixel.
Work with Text Arrow Left Move one character to the left. Arrow Right Move one character to the right. Arrow Up Move up one line. Arrow Down Move down one line. End Move to the end of a line.
Home Move to the beginning of a line. Backspace Delete one character to the left. Delete Delete one character to the right. Arrow Keys Move left and right, up and down, among collections or clips.
Delete Delete selected clip or category. Home Move to the beginning of a row and select the first item. End Move to the end of a row and select the last item. Esc Exit a dialog box. Press either of these keys again to move back to the document and cancel the access keys.
Enter Activate a command or control in the Ribbon so you can modify a value. Enter Finish modifying a value in a control in the Ribbon, and move focus back to the document. F1 Get help on the selected command or control in the Ribbon. If no Help topic is associated with the selected command, the Help table of contents for that program is shown instead. Excel Shortcuts Comments Extends the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, extends the selection to the next nonblank cell.
Deletes one character to the left in the Formula Bar. In cell editing mode, it deletes the character to the left of the insertion point. Removes the cell contents data and formulas from selected cells without affecting cell formats or comments.