Pinterest Stumbleupon Whatsapp
Ads by Google

Keyboard shortcuts are a great productivity technique, and any computer user should have the most important ones memorized. After all, you never know when you’ll have to get around Windows with just your keyboard Navigating Windows with Keyboard Shortcuts Alone Navigating Windows with Keyboard Shortcuts Alone You might know lots of keyboard shortcuts, but did you know you could get around Windows without your mouse? Here's how. Read More !

We’ve shown you how to make Word auto-generate a list of keyboard shortcuts How to Find Every Microsoft Office Keyboard Shortcut You Could Ever Need How to Find Every Microsoft Office Keyboard Shortcut You Could Ever Need Finding a complete list of keyboard shortcuts can be a chore. Let Word automatically generate a list of all of its shortcuts! You'll find keyboard shortcuts for other Office applications, too. Read More , but with hundreds available it can be hard to know where to start. Here are the most important keyboard shortcuts for anyone to know; get these under your belt and you’ll be saving time like you never imagined!

A few notes:

  • Keys appear in bold and keyboard combinations appear in bold, italic font.
  • Control is abbreviated as CTRL.
  • Keyboard shortcuts that need to be pressed at the same time will use a + symbol (e.g. CTRL + S).
  • Combinations that need to be pressed one after another will use a > (e.g. CTRL > T).

All Programs

Let’s get the universal ones that work in all three big Office programs out of the way first. We won’t repeat them in the individual sections.

CTRL + A will select all elements on screen. Depending on where your mouse is focused, the selection could be the entire document/spreadsheet, or only the text box you’re typing in.

Ads by Google

CTRL + B will format text as bold. CTRL + I enables italics, and CTRL + U underlines the selection. Use with CTRL + A to quickly change an entire document or text box.

CTRL + P launches the Print dialogue so you can choose how to print your file Printing Has Changed In Windows 8: Here's What You Need To Know Printing Has Changed In Windows 8: Here's What You Need To Know Printing has changed in Windows 8 – there’s now a standard way of printing in every Modern app. However, like many things about Microsoft’s new Modern interface, printing is not immediately intuitive for many users,... Read More .

CTRL + C will copy the current selection to the clipboard, while CTRL + X will cut it (remove and place it on the clipboard). After using either of these combinations, use CTRL + V to paste it elsewhere. Using a clipboard manager Hold That Thought: 5 Reasons You Need A Clipboard Manager Hold That Thought: 5 Reasons You Need A Clipboard Manager When you think about it, copy paste is kind of weird. You copy stuff, but there's no way to see it. And if you copy over what you had, it's gone – forever. Read More can expand this functionality greatly!

CTRL + Z undoes the last action and can be used several times in a row. To reverse this decision, use CTRL + Y to redo.

The F4 shortcut is quirky but extremely helpful. It will repeat the last action you took, whether that be formatting or deleting text. For example, let’s say you have several headings in a paper you want to be a different font, color, and size than the rest of the text. Instead of manually changing the properties of each line, do it for the first one, then simply highlight the next head and press F4 to apply the same formatting. Its closest ribbon is probably the format painter.

The Ribbon interface is great How To Tweak The Windows And Office Ribbon Menu How To Tweak The Windows And Office Ribbon Menu That pesky Ribbon Menu. Ever since its introduction in Office 2007, I’ve been struggling to come to terms with it. I much preferred the Office 2000/2003 method of “hiding” tools that you don’t use often... Read More , but if it’s in your way, CTRL + F1 hides it. Press again to bring it back.

Office includes a built-in thesaurus and dictionary. Highlight a word and use SHIFT + F7 to pop open the thesaurus tab, where you can see a word’s definition and synonyms What’s The Good Word: Here Are 6 Ways To Use Google As An Instant Dictionary What’s The Good Word: Here Are 6 Ways To Use Google As An Instant Dictionary We Google for stuff anyway, and perhaps it has almost become a sub-conscious habit to Google for a word meaning as well. Google certainly makes it easy with the different ways it gives us to... Read More .

When you need to add a hyperlink to some text to link to another file or a Web address, CTRL + K brings you to the dialogue box instantly.

You should save your documents often! A quick tap of CTRL + S will do the trick.

When working with multiple files in one Office program, use CTRL + F6 to switch between them.

If you need to locate something in the current file quickly, CTRL + F will open the Find box.

Word

When you’re typing away in Word, remember these keyboard shortcuts to save time. They’re much more efficient than hunting through layers of menus for an uncommon setting.

Students will appreciate this one: access Word’s built-in word counter by pressing CTRL + SHIFT + G. Hopefully, you have enough words!

Before you send that important document off, give F7 a tap to open Spelling and Grammar. Spell-checking in Word 8 Ways To Spell & Grammar Check In Microsoft Word Using Different Dictionaries & Languages 8 Ways To Spell & Grammar Check In Microsoft Word Using Different Dictionaries & Languages Microsoft Word's built-in spelling and grammar checking tools can be customized to meet your needs. You can even use AutoCorrect to speed up your typing. Read More is always a good idea, but try some other grammar-checking tools Improve Your Grammar & Spelling With These Free Office & Browser Extensions Improve Your Grammar & Spelling With These Free Office & Browser Extensions Default spell checkers can set you up for epic failure! Imagine how a grammatical error on a job application could work against you. Here are three tools that can check both spelling and grammar. Read More to ensure Word didn’t miss anything.

Caps lock is really annoying, and you probably only enable it by accident Isn't It Time You Made Use of Your Caps Lock? Isn't It Time You Made Use of Your Caps Lock? The CAPS LOCK key is probably the most useless key on your keyboard. Netiquette forbids you to use it because it's considered screaming, which is simply rude. And what else would you use it for... Read More . Next time you type a paragraph in all caps, highlight the text and use SHIFT + F3 to toggle between lowercase, all caps, and title case (Capitalizing The First Letter Of Each Word).

Word will auto-format common superscript uses (such as dates) but when you need to do it manually, use CTRL + = to subscript highlighted text, or CTRL + SHIFT + = to make it a superscript.

When you insert a URL, Word will automatically turn it into a hyperlink and make it blue. You might not want this on formal documents like resumes, so use CTRL + SHIFT + F9 to remove any hyperlinks in text.

Though you can copy and paste text without the formatting 5 Ways to Strip the Formatting When You Copy & Paste Text 5 Ways to Strip the Formatting When You Copy & Paste Text Carrying all the rich text formatting along when copying and pasting text is irritating. Here are multiple ways to avoid that. Read More , sometimes you have to deal with someone else’s wacky formatting. When this happens, simply highlight the text and press CTRL + SPACE to remove any font effects and reset it to the default size, font, and color.

There are multiple places you can adjust font size, but get fancy with your keyboard and use CTRL + ] to increase the font size and CTRL + [ to decrease it.

The on-screen ruler is visual clutter, if you’re not actively using it. ALT > W > R toggles the ruler.

Excel

Excel has a bit of a learning curve, but getting used to these shortcuts will have you well on your way to whizzing through spreadsheets.

You probably have several tabs in your Excel workbook; use CTRL + Page Up/Page Down to scroll between them.

Ever found yourself in cell CDZ-2108 with no idea of how you got there? Pressing CTRL + Backspace will focus the screen on the active cell, so you don’t have to hunt for it.

This is less of a shortcut and more of a basic command, but it isn’t well-explained. To enter a new line in a cell, use ALT + ENTER.

Today’s date/time are common items you might want to enter in a cell. Use CTRL + ; to quickly enter the current date or CTRL + Shift + : for the current time; don’t forget about using text expansion to make shortcuts What Is Text Expansion & How Can It Help You Save Time? What Is Text Expansion & How Can It Help You Save Time? If you could save yourself even a small fraction of the time you spend typing, you could save hours of your time every week. That's exactly what text expansion is for. Read More like this yourself!

Excel doesn’t allow you to change the formatting of text as easily as Word or PowerPoint do. Press CTRL + 1 on any cell to open the Formatting dialogue box.

Formulas are what make Excel so powerful Need Help with Excel Formulas? 7 Resources to Consult Need Help with Excel Formulas? 7 Resources to Consult Excel is the spreadsheet gold standard. If you are required to use Excel and yet have to familiarize yourself with it, these resources will quickly introduce you to the basics and more. Read More . You probably spend a lot of time editing them, so press F2 to jump to the formula box instead of using the mouse.

To toggle between cells showing their content or their formulas, use CTRL + ` (the key below ESC on a US QWERTY keyboard layout A History of Keyboard Layouts, Is QWERTY Lagging Behind? A History of Keyboard Layouts, Is QWERTY Lagging Behind? QWERTY is over 100 years old. It's outdated and outclassed by several alternatives, yet it's still the most popular keyboard layout in the world. How did we get here? Read More ). This is useful for ensuring each cell that should have a formula actually does.

Try CTRL + 0 to hide a column, or CTRL + 9 to hide a row. You can unhide anything hidden by this shortcut using CTRL + Shift + 0/9, but it may require a weird workaround due to Windows keyboard settings. If you can’t use that method, the sequence ALT > H > O > U > L will do the same thing.

The SUM function is common, and you can use ALT + = to automatically apply SUM to any highlighted cells.

CTRL + Arrow Keys is an interesting one; it will warp in the direction you choose, stopping when it hits a blank space if you start in a filled cell. If you start in a blank cell, it will stop when it hits one that isn’t blank. You can use it to quickly jump to the furthest regions of Excel!

Similarly, CTRL + Shift + * will select the current range – this means all directions from the current cell until it hits the edge of the worksheet or a completely blank row or column. It sounds a bit weird, but try it out and you’ll understand.

PowerPoint

Next time you’re responsible for making an impressive presentation 5 Powerpoint Tips to Improve Your Presentation Skills Overnight 5 Powerpoint Tips to Improve Your Presentation Skills Overnight You step up to the podium. Your palms are sweaty, your heart is racing, and just as you're about to open your mouth and speak, your mind goes blank. Need help? Read More , remember these tips to zoom through your work.

Note that since PowerPoint’s editor view shares many of its shortcuts with Word (try any of the above in PowerPoint!), this section will focus on shortcuts while presenting your slides.

CTRL + M will add a new slide in the editor.

Press CTRL + Shift + D to duplicate the current slide.

Press F5 to launch a slideshow from the beginning, or CTRL + Shift + F5 to start from the current slide.

To jump to a certain slide while presenting, press a number and then Enter.

If there’s ever an emergency with a slide or you quickly need to black out the display to keep everyone’s focus, press B to display a blank black slide. Press it again to return to where you were. If you prefer a white slide, use W instead.

PowerPoint includes tools 5 Creative Uses Of PowerPoint Presentations You Haven't Explored Yet 5 Creative Uses Of PowerPoint Presentations You Haven't Explored Yet Microsoft PowerPoint can do much more than boring presentations. It’s PowerPoint 2013’s time now and the search for creative and uncommon uses of PowerPoint continues. Here are five. Read More that let you interact with slides as they’re being displayed. Don’t fumble around with the mouse in front of your audience to find these – use CTRL + P to activate the pen tool, and once you’re done drawing press E to clear the ink.

To bring up your mouse cursor while presenting use CTRL + A. CTRL + H will hide your mouse pointer, whether it’s an arrow or pen.

If your presentation is automatic (perhaps displayed at a kiosk), press S to stop or restart the slideshow.

Got media embedded into a slide How to Embed a YouTube Video & Other Media in Your PowerPoint Presentation How to Embed a YouTube Video & Other Media in Your PowerPoint Presentation Typical presentations are dull affairs with text and corporate backgrounds providing little of interest. Media files can lighten up the experience. We show you how to embed even videos. Read More ? Use ALT + P to toggle play/pause, or ALT + Q to stop playback. ALT + Up/Down Arrows will adjust the volume, while ALT + U will mute.

Get Your Shortcut On

A lot of shortcuts are represented here, but they’re not too much for you to learn! You’ve probably recognized functions you use every day in this list; commit those to memory Memorize Anything Using Active Recall Memory Memorize Anything Using Active Recall Memory Your memory sucks, but it's nothing you can't improve. Whether you're trying to learn a language, geography or even basic programming skills, active recall learning lets you commit details to memory. Read More and watch your productivity soar. There’s no shame in keeping this list open for a while until you can recall them at any time.

Can’t get enough shortcuts? Browse our ultimate keyboard shortcut guide Windows Shortcuts 101 - The Ultimate Keyboard Shortcut Guide Windows Shortcuts 101 - The Ultimate Keyboard Shortcut Guide With so many shortcuts built into Windows and its software, it might seem impossible to learn them all. Here's the ultimate guide to the most useful keyboard shortcuts. Read More for dozens more!

What are your top Office shortcuts? Did you learn any new ones in this list that you’re excited about? Give us your thoughts in a comment below!

Leave a Reply

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