![mac excel keyboard shortcut dragging cell to the very end mac excel keyboard shortcut dragging cell to the very end](https://cdn.extendoffice.com/images/stories/doc-excel/apply-formula/doc-apply-formula-02.png)
![mac excel keyboard shortcut dragging cell to the very end mac excel keyboard shortcut dragging cell to the very end](https://www.excelcampus.com/wp-content/uploads/2019/09/Select-Used-Cells-in-a-Column-with-Ctrl-Shift-Down-Arrow.png)
The most popular of this group are the navigation shortcuts. There are also shortcuts that combine Ctrl and Shift. Just as Ctrl helps you “jump” on the worksheet, Shift enables you to select cells. You can use this with the other arrow keys as well. For example, Shift+F11 opens a new worksheet and Shift+→ selects an expanding range of cells as you keep typing → or just hold → down. While not as common as Ctrl shortcuts, there are some useful Shift shortcuts. Use Ctrl shortcuts that involve the right hand only when doing so is faster than the alternatives (for example, Ctrl+End to jump to the farthest used cell). For purposes of speed, I highly recommend that you use any Ctrl shortcuts that can be accomplished by the left hand (such as those just mentioned). For example, Ctrl+C for Copy, Ctrl+V for Paste and Ctrl+S for Save. Many of the most popular Excel shortcuts involve typing Ctrl and a letter or number (or an arrow or an F-key). Hybrid shortcuts (which use both the mouse (typically right-clicking) and the keyboard)īelow, I’ll go through each type of shortcut briefly, with a few examples of each.īut first, here is an animation of Alt shortcuts to whet your appetite:.Mouse shortcuts (which use the right-click menu).QAT shortcuts (which use the Quick Access Toolbar).Ctrl+Shift shortcuts (which use the Ctrl and Shift keys together).
![mac excel keyboard shortcut dragging cell to the very end mac excel keyboard shortcut dragging cell to the very end](https://www.excelcampus.com/wp-content/uploads/2020/10/Fill-Down-Techniques-to-fill-blank-cells.png)
Shift shortcuts (which use the Shift key).Ctrl shortcuts (which use the Ctrl key).How Many Types Of Excel Shortcuts Are There?Įxcel shortcuts come in eight basic flavors (there are more but these are the main ones):