Excel Shortcuts - List of the most important & common MS Excel shortcuts for PC & Mac users, finance, accounting professions. Keyboard shortcuts speed up your modeling skills and save time. Learn editing, formatting, navigation, ribbon, paste special, data manipulation, formula. Press Option-Tab to convert the current line into a list item Press Return to create another list item Press Tab at the start of a blank list item to indent it, creating a sublist. Start typing the word. Press Option–Esc (or F5) to open suggested word list: Switch to Outline Mode in TextEdit: Press Option-Tab to convert the current line into a list item; Press Return to create another list item; Press Tab at the start of a blank list item to indent it, creating a sublist; Press Shift-Tab to remove a level of indention.
This is the ultimate guide for working with MacBook keyboards, including accessing special functions, characters, accents, and using keyboard shortcuts in Mac OS system. Click on the list below to jump to an appropriate section.
MacBook Keyboard Diagram / Map
MacBook keyboard has few distinctive sections: Function keys (in light blue), which provides access to various functions in MacBook itself or Mac OS system. By combining them with the FN key, you'll get access to F1 - F12 keys, which can be associated with particular application features (useful in Photoshop for example).
The second section is the modifier keys (in light yellow). Shift allows to type uppercase letters and other additional characters. Command and Alt/Option are used in keyboard shortcuts, as well as the Control key, which is used almost exclusively by Mac OS X and Apple programs. Pokemon liquid crystal walkthrough pdf download.
Return and left Shift has two variants, one used in the US and Eastern Asia (horizontal Return and long Shift), and second, used in Europe, Middle East and Africa (vertical Return and short left Shift). On the diagram, this is shown by dashed lines. Of course, MacBook keyboards have lots of localizations, the most common - US English - is shown above. If you're unsure about the localization you have, go and check it with this guide.
MacBook Air 11' has slightly different keyboard, with smaller top and bottom row keys to accommodate smaller laptop size. Newest MacBooks Pro with TouchBar don't have upper F keys row, instead, they have a touchscreen which changes displayed options based on context.
MacBook Keyboard Symbols Chart
Symbol | Meaning | Notes |
Screen brightness down | ||
Screen brightness up | ||
Launches Mission Control | Icon available on MacBooks Unibody | |
Launches Mission Control | Icon available on MacBooks pre-unibody | |
Launches Dashboard | Icon available on MacBooks Unibody | |
Launches Dashboard | Icon available on MacBooks pre-unibody | |
Keyboard backlight down | ||
Keyboard backlight up | ||
Rewind | ||
Play / Pause | ||
Fast Forward | ||
Sound: mute | ||
Sound: volume down | ||
Sound: volume up | ||
Eject | Available on MacBooks with CD/DVD drive | |
Power | Available on MacBooks without CD/DVD drive | |
Command | On MacBooks 1st generation this is replaced by Apple logo | |
Alt / Option | Available on European/ISO keyboard layouts | |
Tab | Available on European/ISO keyboard layouts | |
Backspace | Available on European/ISO keyboard layouts | |
Shift | Available on European/ISO keyboard layouts | |
Caps Lock | Available on European/ISO keyboard layouts | |
Return | Available on European/ISO keyboard layouts | |
Enter | Available on European/ISO keyboard layouts, accessed with FN key | |
Delete | Not on MacBooks, but worth knowing | |
Clear | Not on MacBooks, but worth knowing | |
Home | Not on MacBooks, but worth knowing. Can be substituted by CMD + up arrow shortcut. | |
End | Not on MacBooks, but worth knowing. Can be substituted by CMD + down arrow shortcut. | |
Page Up | Not on MacBooks, but worth knowing | |
Page Down | Not on MacBooks, but worth knowing | |
Arrows | Used to move things or pointer |
MacBook Keyboard Special Characters and Accents Map
If you want to type special characters or accents, change your keyboard language to US International PC (thanks, Steve!) and use the map below to get them. You can also check out our solution to the two languages on one keyboard problem.
Where is the Print Screen Button?
Unlike PC keyboard, there is no Print Screen key on MacBook keyboard. This functionality is accessed by keyboard shortcuts and - on Mac - you have greater flexibility:
- Command + Shift + 3 - captures entire screen;
- Command + Shift + 4 - captures selected region. Your cursor turns to crosshair and by clicking and dragging you can specify which area you want to capture;
- Command + Shift + 4 + Space - captures selected window. First press the shortcut from above, then - when you have crosshair - hit Space. The cursor will turn to the camera and the active window will have a blue overlay. Click on it to get it captured.
In some apps, like Photoshop, you need to add Control into the mix, to paste the screenshot into the app.
MacBook Keyboard Tricks
There's a lot you can do in Mac OS by using the keyboard only. Here's a list of highly useful and not-so-useful keyboard shortcuts:
Shortcut | Action |
Command + W | Quickly closes the active window in Safari or any other browser. Works also with many applications, like Pages, Numbers, Photoshop. Great way to quickly close something when your boss is coming around :) |
Command + H | Hides the active application. Useful for hiding something quickly ;) |
Option + Shift + F11/F12 | Makes tiny changes in volume level instead of standard jumps. |
Control + Option + Command + 8 | Reverses colors on the screen. |
1, 2, 3, 4, 5, 6, 7, 8, 9 | When watching YouTube video, this will advance you to 10%, 20%, 30%. of movie completion. |
Option + Delete | Deletes whole word in text editors |
Control + Command + V | Pastes copied text without formatting. Useful when copying something from Pages and pasting into eg. Wordpress :) |
Control + Command + Option + Eject/Shutdown | Shuts down the MacBook without the need to provide username and password. |
Command + Shift + A | Opens the Applications folder in Finder. |
Command + Shift + U | Opens the Utilities folder in Finder. |
Command + Shift + D | Opens the Desktop folder in Finder. |
Command + Shift + I | When in Safari, this shortcut copies the URL, opens Mail app and creates a new email with the copied URL pasted as a link in a message. |
Command + Option + M | Minimizes all open windows, showing Desktop. |
Command + Option + Shift + Esc | Hold for 3 seconds to force quit any app. |
Command + Tab | Cycle through opened apps from left to right. |
Command + Shift + Tab | Cycle through opened apps from right to left. |
Command + ` | Cycles through active app windows. |
Command + Q | Quit active app. |
Command + T | Opens a new tab in Finder. Opens a new tab in a web browser. |
Command + N | Creates new Finder window. |
Command + Shift + N | Creates new folder in Finder. |
Command + Space | Launches Spotlight. |
Command + Option + Space | Switches to next keyboard language (if you have more than one). |
Command + Control + Space | In some websites and apps this will give you the emoji keyboard. |
Command + Delete | Sends selected files/folders to trash. |
Fn + Delete | Deletes text from left to right. |
F10 + Shutdown | Hold while launching MacBook to get a silent start. |
Command + up arrow/down arrow | Jump to the beginning or end of a page. This is equivalent to PC's Home and End keys. |
Command + up arrow + L | Highlights the address bar in a web browser. |
- Command + Shift + 3 - captures entire screen;
- Command + Shift + 4 - captures selected region. Your cursor turns to crosshair and by clicking and dragging you can specify which area you want to capture;
- Command + Shift + 4 + Space - captures selected window. First press the shortcut from above, then - when you have crosshair - hit Space. The cursor will turn to the camera and the active window will have a blue overlay. Click on it to get it captured.
In some apps, like Photoshop, you need to add Control into the mix, to paste the screenshot into the app.
MacBook Keyboard Tricks
There's a lot you can do in Mac OS by using the keyboard only. Here's a list of highly useful and not-so-useful keyboard shortcuts:
Shortcut | Action |
Command + W | Quickly closes the active window in Safari or any other browser. Works also with many applications, like Pages, Numbers, Photoshop. Great way to quickly close something when your boss is coming around :) |
Command + H | Hides the active application. Useful for hiding something quickly ;) |
Option + Shift + F11/F12 | Makes tiny changes in volume level instead of standard jumps. |
Control + Option + Command + 8 | Reverses colors on the screen. |
1, 2, 3, 4, 5, 6, 7, 8, 9 | When watching YouTube video, this will advance you to 10%, 20%, 30%. of movie completion. |
Option + Delete | Deletes whole word in text editors |
Control + Command + V | Pastes copied text without formatting. Useful when copying something from Pages and pasting into eg. Wordpress :) |
Control + Command + Option + Eject/Shutdown | Shuts down the MacBook without the need to provide username and password. |
Command + Shift + A | Opens the Applications folder in Finder. |
Command + Shift + U | Opens the Utilities folder in Finder. |
Command + Shift + D | Opens the Desktop folder in Finder. |
Command + Shift + I | When in Safari, this shortcut copies the URL, opens Mail app and creates a new email with the copied URL pasted as a link in a message. |
Command + Option + M | Minimizes all open windows, showing Desktop. |
Command + Option + Shift + Esc | Hold for 3 seconds to force quit any app. |
Command + Tab | Cycle through opened apps from left to right. |
Command + Shift + Tab | Cycle through opened apps from right to left. |
Command + ` | Cycles through active app windows. |
Command + Q | Quit active app. |
Command + T | Opens a new tab in Finder. Opens a new tab in a web browser. |
Command + N | Creates new Finder window. |
Command + Shift + N | Creates new folder in Finder. |
Command + Space | Launches Spotlight. |
Command + Option + Space | Switches to next keyboard language (if you have more than one). |
Command + Control + Space | In some websites and apps this will give you the emoji keyboard. |
Command + Delete | Sends selected files/folders to trash. |
Fn + Delete | Deletes text from left to right. |
F10 + Shutdown | Hold while launching MacBook to get a silent start. |
Command + up arrow/down arrow | Jump to the beginning or end of a page. This is equivalent to PC's Home and End keys. |
Command + up arrow + L | Highlights the address bar in a web browser. |
If this article was helpful or you simply like what we do, please use buttons below to share this article with the world :-) Thanks!
Please enable JavaScript to view the comments powered by Disqus.You may also be interested in.
I Hated MacBook Cases, Here's Why I Changed my Mind.
If you asked me about MacBook cases or iPhone silicone covers 5 years ago, I would probably cry and then say one big fat 'noooo'! Why? I had my reasons, mostly because I got my MacBook almost killed by using them, not even counting how many times its life was in serious danger. If you're thinking about getting a MacBook case, make sure to read this article first.Read more
16 Questions About Keyboard Stickers You Always Wanted to Ask and One Extra Surprise at the End
You probably heard of multiple advantages of having your keyboard covered with decorative or specialized keyboard decals. Want to get your first keyboard stickers but still not sure how these work? Then check out these 16 questions (and answers of course) we prepared for you to clear up all doubts!Read more
9 Reasons to Get Keyboard Stickers Instead of Silicone Cover
Ahhh. keyboard stickers versus silicone covers - it's like Mac vs Windows, each side has its own believers and haters. By the headline you already know where we stand - and we do it with a reason.Read more
- Most recent
Humanity should be grateful for the invention of Mac hotkeys. They probably saved us thousand years of time if put together. There is something addictive in using shortcuts - the quickness, the feeling of a keyboard, the geeky confidence in your fingers when you realize 'hurray it works!' Once you get hooked on shortcuts, you'll never go back to clicking again.
Basic Mac hotkeys combinations
1. Quit all apps
Sometimes an app that you thought you quit is still secretly running in the background. When your Mac lags and you need some fresh memory, you may choose to quit all apps. You probably heard of Force Quit (Cmd + Option + Esc), but it's a too long way to do it.
Quit many apps in a row: Cmd + Tab
Then, holding down Cmd press Q to cycle between apps you need to close.
2. Delete a file completely
Dragging files to the Trash? Wait, this is not the only option. Here's a shortcut to quickly delete unwanted files on a Mac, bypassing the Trash. Caution: there's no way back. Apple wifi storage.
To completely delete a file: Option + Cmd + Delete
Did you know, the Command key ? symbol was borrowed from a road sign that is used across Scandinavia? Its original use is to denote tourist attractions. Early Mac models had Apple key instead of Command, but it later was changed as Steve Jobs feared that there would be too many 'apples' in the OS interface.
3. Copy and paste a screenshot directly
Cmd + Shift + 4 is an old classic way to make a screenshot on a Mac. But here comes the combination to take your screenshotting skills to the new level. Normally you would make a screenshot, pick it from your desktop, and only then paste it to the new location. It appears, all this time you could do it easier.
To copy-paste a screenshot: Shift + Control + Cmd + 4
4. Quickly switch to the desktop
Sometimes your screen is so obscured by windows it would take years to click through to the desktop. Thank goodness, there is a Mac keystroke combination designed for people like us: the folks who are drowning in an ocean of windows.
To remove window overload: Cmd + F3
5. Open Spotlight
Spotlight, your Mac's internal search engine, can make your life 1000% easier. It finds files faster than Finder and intuitively predicts what are you after. To open Spotlight right on the spot (sorry for the pun), use this magic combo.
To launch Spotlight search: Cmd + Space bar
Cool shortcut keys for Mac
1. Invert display colors
Winx dvd ripper 4 6 3. A truly psychedelic key combination. This shortcut inverts all the colors on your Mac's screen to their opposites. Try it, and your world will never be the same. On the flip side, you can find a few practical applications for this command, for example, to adjust your screen to different lighting.
To invert colors on screen: ?md + Option + F5
2. Restore a recently closed tab
This one can be a real savior if you accidentally closed an important tab in a browser, like that pancake recipe or payment confirmation. There's an easy Mac keyboard shortcut to restore it.
To restore a closed tab: Cmd + Shift + T
3. To shut down your Mac instantly
No, the following Mac shortcut is not about the force shutdown. It's used when you need to quickly close all dialog windows and shut down your Mac in a legit way. Learn this one, quickly finish your work and finally go outside.
Macbook Pro Shortcut Keys List
To quickly shut down a Mac: Control + Option + Command + Eject
4. Mac hot keys to invoke Siri
Among all Mac keyboard commands, this is the easiest. Since Siri's arrival to macOS we got used to talk to Siri about weather and even ask her to play our favorite tracks on Mac. If you are using macOS Sierra or higher, you'll enjoy the ability to summon Siri using just one hand.
To launch Siri: Cmd + Space bar
See All Results For This Question
A shortcut to free up space on your Mac
Well, not exactly a shortcut, but indeed the quickest way to get more storage on your Mac.
See Full List On Dummies.com
Download CleanMyMac + Install + Click Smart Scan
This combination of actions will free up dozens of gigabytes of space taken by garbage: unwanted files, system junk, app leftovers, etc. CleanMyMac removes about 54 GB of junk on an average Mac. Try and see how it cleans your Mac.
CleanMyMac is available for a free download here.
Finder shortcuts
Finder is quite a resource-demanding tool. When you open a new Finder window it usually takes some time. For quicker access to your main destinations like Applications or Desktop, you can use the following shortcut combinations.
To quickly access Finder folders:
Cmd + Shift + A (for Applications)
Cmd + Shift + U (for Utilities)
Cmd + Shift + D (for Desktop)
Chrome shortcuts
Having hundreds of opened tabs in a browser has become a widespread syndrome nowadays. Closing tabs with a mouse is not only frustrating but also may freeze up your browser. Using a direct shortcut makes this job easy as a morning walk.
To close a current tab in Chrome: Cmd + W
To close a Chrome window: Cmd + Shift + W
To open a new Chrome tab: Cmd + T
Psychologists say you have to do something at least 3 times to put it in your long-term memory. Attach small sticky notes to the outlines of your Mac's screen with 3 or 4 shortcuts you really want to master. Then, leave it all to your fingers.
Mac shortcuts for documents
1. Copy text without formatting
You want to copy a piece of the text, but the old formatting drags along with it. Now you spend more time formatting rather than actually creating a text. To strip the text from old styling, use the following Mac hotkeys combination. A very good one to stretch your fingers.
To paste text without formatting:
Hold down Shift + Option + Command and hit V
2. Paste special symbols and emojis
Probably this is the easiest documented shortcut key for a Mac. To enter special symbols, like those lamdas, tildas, and alfas, you need to press just one key. For instance, if you need to type a modified E, hold down the E key for one second and then choose among available variations that appear.
To enter an alternate character: Hold down the character key
To paste emojis in the text: Press Control + Command + Space
3. Enter a strikethrough text on a Mac
You won't believe, but 8000 people are googling how to do a strikethrough text on a Mac everyday. Although some applications don't support it, this combination well works in TextEdit and Word. Now you can use it in every second line to add some roughness to your writing.
To apply strikethrough formatting: Cmd + Shift + X
4. Quickly print documents
The next combination works for most apps that allow printing. You don't need to figure out where the print dialogue is located in every case. Just memorize this quick combination and send your files to print from anywhere.
To invoke a print dialogue: Cmd + P
Mac shortcuts to delete many files at once
There comes a time when you need to do a spring cleaning on your Mac: sort out old garbage, move photos to an external drive, or clean up your old downloads. It is time-consuming and takes an immense willpower simply to start. But lucky you are: there are a few shortcuts to remove large heaps of files as quickly as if you had a machete.
To select folder contents: Cmd + A
To delete a group of files after selection: Cmd + Delete
To empty the Trash: Cmd + Shift + Delete
If you've got many files left after backing up, this will save you a good deal of time moving them to the Trash bin.
To save you from a headache, there are apps that will do the mundane deletion job in an instant. CleanMyMac is perhaps the most reliable one. It has a tool that specifically searches for Large & Old files on your drive for a quick cleanup. CleanMyMac is available for a free download. So, check it out.
This was our take on most useful keyboard shortcuts for Mac. Thanks for reading. Below you'll find a few more links about Mac and productivity.