What's this keyborad shortcut to do?
- Displays the Key Tips (new shortcuts) on the ribbon.
- Press and release the Alt key.You see the little boxes called KeyTips over each command available in the current view.
- Press the letter shown in the KeyTip over the command you want to use.
- Depending on which letter you pressed, you might see additional KeyTips. For example, if the Home tab is active and you pressed N, the Insert tab is displayed, along with the KeyTips for the groups in that tab.
- Continue pressing letters until you press the letter of the specific command you want to use.
- Tip: To cancel the action you’re taking and hide the KeyTips, press and release the Alt key.
For example,
- Alt, W, P switches the worksheet to Page Layout view.
- Alt, W, L switches the worksheet to Normal view.
- Alt, W, I switches the worksheet to Page Break Preview view.
Windows shortcut
Alt
Mac shortcut
N/A
Notes:
- 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.
- A plus sign (+) in a shortcut means that you need to press multiple keys at the same time. For example: Ctrl+Alt+Del means: Press and hold the Ctrl key and the Alt key and whilst holding them down, press and release the Del key.
- A comma sign (,) in a shortcut means that you need to press multiple keys in order. For example: Alt+H,H means: Press and hold the Alt key and whilst holding it down, press and release the H key, then press and release the H key.
- The left and right side key on the keyboard perform the same function. For example: Ctrl+A, you can press left Ctrl key or right Ctrl key.
Why You Should be Using Keyboard Shortcuts
- 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.
- 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.
- 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.
- Complementarity: You can combine the advantages of using the keyboard with those of using the mouse.
- Precision: When you have a job that requires precision it is advisable that you use the keyboard.