Keyboard Shortcuts for Excel on Windows and Mac One way of speeding up Excel is to integrate keyboard shortcuts in your workflow. Excel experts hardly use a mouse at all, because using a mouse takes more time and is often not precise. Mac-compatible keyboard (has a Command key, not Windows) Directions: First up, take a look at the Mac keyboard in front of you to familiarize yourself with a few Mac-specific keys.
Before we start: Do you want to download the complete package of keyboard shortcuts in Excel? Just sign up for our and you’ll get the download link. Different Types of Excel Keyboard Shortcuts There are two main types of keyboard shortcuts: • Accessing the ribbon (“Alt” shortcuts) • Direct shortcuts Accessing the Ribbon Shortcuts The first type of keyboard shortcuts accesses the ribbon. You can try it by pressing the Alt-key. After pressing Alt key, letters will be shown on the ribbon. Press one of these letters and the corresponding ribbon will open. New letters show how to access each specific function.
This type is easy to use as you are guided through it. You don’t even have to remember the complete shortcut, but just on which ribbon your desired function is located. Direct Shortcuts The second type comprises all other shortcuts. Some of them require the Ctrl key or others function keys (F1, F2, e.g.). One of the advantages is that they are usually shorter than ribbon shortcuts.
Furthermore, many of the direct shortcuts are the same in other Windows programs (Word, PowerPoint, Windows Explorer e.g.) or similar on other platforms (Mac). The disadvantage is that you have to remember them. Some may be easy to be memorized, while some are quite difficult. When direct shortcuts are available, they are usually shown when the mouse is moved to a function on the ribbon. The corresponding description text will appear. Which Shortcuts should I remember?
This highly depends on what you do with Excel. If you use Excel only for keeping a To-Do-List, the keyboard shortcuts that you require, could be very different from those you need for financial controlling purpose for your company.
But anyway, the following list provides shortcuts for different tasks on a Windows computer and Mac. You can download them as a pdf document, print it out and stick at your computer screen. This serves as a daily help and eventually you could memorize the shortcuts. • • Excel Keyboard Shortcuts Windows.
How Windows Keyboard Shortcuts Compare to Mac Shortcuts Keyboard shortcuts are combinations of key presses that let you carry out a task without navigating through the menus. PCs have two kinds of keyboard shortcuts. For some, you hold down the Ctrl key and a letter key; for others, you press the Alt key and type one letter from each menu item name — often, but not always, the first letter. Mac keyboard shortcuts are like the first type, but you use the Command key instead of the Ctrl key. Following are examples of Mac keyboard shortcuts: Keyboard Shortcut Act ion Command+C Copy Command+X Cut Command+V Paste Command+A Select All Command+F Find Command+G Find Again Command+S Save Command+Z Undo Replacing the Ctrl key press with the Command key also applies to most Ctrl key shortcuts in programs, such as Microsoft Office.
The letters in keyboard shortcut combinations are always shown capitalized on-screen, but the Mac recognizes the lowercase versions as well. Thus, you can type either Command+Q or Command+q to quit (exit) the program. Although the Mac OS X menu layout appears to be intuitive and easy to follow, Apple does get a little carried away with shortcuts.
There are dozens of them, so don’t try to remember them all. OS X displays the available shortcut for each menu item right in the drop-down menu itself.
Some combinations use different and even multiple control keys. Apple uses other symbols in addition to the Command symbol and Apple symbol to indicate these keys: • Option: This key often modifies a shortcut or menu item by telling it to do more. So, for example, Command+W closes the front window. Option+Command+W closes all windows for the front application. Shortcuts can be complex.
The shortcut in TextEdit for Edit→Paste and Match Style is Option+Shift+Command+V. • Control: This key’s symbol looks like a hat. The key is pressed in combination with a mouse click to mean right-click. • Shift: Either the right or left Shift key may be used, but caps lock has no effect on shortcuts that include a Shift key. • Escape: This key’s symbol looks a lot like the power button icon, but it’s different. The line is at an angle and has a little arrow pointing out. Escape is a shortcut for Cancel in dialog boxes.