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

What's this keyborad shortcut to do?

  • In a dialog, performs the action for the selected button, or selects or clears a check box.
  • Activate or open selected control in Ribbon.
  • Toggle pivot table field checkbox in Pivot Tables.


  • Ctrl+Spacebar selects an entire column in a worksheet.
  • Shift+Spacebar selects an entire row in a worksheet.
  • Ctrl+Shift+Spacebar selects the entire worksheet.
  • If the worksheet contains data, Ctrl+Shift+Spacebar selects the current region. Pressing Ctrl+Shift+Spacebar a second time selects the current region and its summary rows. Pressing Ctrl+Shift+Spacebar a third time selects the entire worksheet.
  • When an object is selected, Ctrl+Shift+Spacebar selects all objects on a worksheet.
  • Alt+Spacebar displays the Control menu for the Excel window.
Windows shortcut
Mac shortcut

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>