End

Excel Shortcut: End
Excel Shortcut: End (US keyboard layout)

What's this keyborad shortcut to do?

  • End turns End mode on or off. In End mode, you can press an arrow key to move to the next nonblank cell in the same column or row as the active cell. End mode turns off automatically after pressing the arrow key. Make sure to press End again before pressing the next arrow key. End mode is shown in the status bar when it is on.
  • If the cells are blank, pressing End followed by an arrow key moves to the last cell in the row or column.
  • End also selects the last command on the menu when a menu or submenu is visible.

More:

  • Ctrl+End moves to the last cell on a worksheet, to the lowest used row of the rightmost used column. If the cursor is in the formula bar, Ctrl+End moves the cursor to the end of the text.
  • Ctrl+Shift+End extends the selection of cells to the last used cell on the worksheet (lower-right corner). If the cursor is in the formula bar, Ctrl+Shift+End selects all text in the formula bar from the cursor position to the end—this does not affect the height of the formula bar.
Windows shortcut
End
Mac shortcut
Fn+

Why You Should be Using Keyboard Shortcuts

  1. Efficiency: Many users find that using keyboard shortcuts for Excel helps them work more efficiently. In other words, using keyboard shortcuts could save you a lot of time, it's easier and gets your job done faster.
  2. Multitasking: Be a master at multitasking when needed. For example, when you are coding, writing reports or doing some research, it's common to end up juggling dozens of open tabs at once. Knowing the right shortcuts allows you to easily find the tab you need in less than a second.
  3. Health benefits: Cutting down on your mouse usage by using keyboard shortcuts can help reduce the risks of RSI (Repetitive Syndrome Injury). By alternating mouse and keyboard usage you can reduce the risks of R.S.I. and reduce the fatigue your wrists and fingers.
  4. Complementarity: You can combine the advantages of using the keyboard with those of using the mouse.
  5. Precision: When you have a job that requires precision it is advisable that you use the keyboard.

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>