I’m not sure why Microsoft decided that the ribbon tabs should be in all caps, but if you feel like your version of Word is shouting at you, here’s how to change the tab names to Title case.
Office 2013 applications default to Backstage View (the view when you click the File tab) whenever you click Open, Save, or Save As. Unfortunately, this adds way too much clicking for those of us who work with a lot of files.
To make matters worse, if you add Open and Save icons to the Quick Access toolbar, they also default to Backstage View when clicked.
Fortunately, Microsoft included an option to turn off this feature.
To bypass Backstage View whenever you open or save a file:
Office 2013 has many great new features, but the new Start Screen is not one of my favorites. It’s fine if you want to play around with templates or search for a template online, but I usually want to get directly to a document (or spreadsheet, etc.) without unnecessary clicks.
To bypass the Office 2013 Start Screen and go directly to the traditional “New Document” screen:
If you need to enter the same data into multiple cells in Excel, it’s easy with this simple trick.
Selecting a large range in Excel by dragging the mouse can be difficult.
Try using the SHIFT key when you select a range that extends beyond what is displayed on your screen. You can do this two ways:
As an alternative, you can start by clicking into the upper left corner of the range, then hold down the SHIFT key, while clicking into the cell in the low
er right corner of the range.
The location of the Templates folder varies in different versions of Windows, so here is a quick way to access it even if you don’t know where it is:
The folder contains the normal template used in Word, any custom or downloaded PowerPoint templates, and custom Excel, Outlook, and Publisher templates.
Protected View is a new safety feature in Office 2010 that lets you view a document, but prevents it from running macros that might contain malware. By default, it opens any document downloaded from the Internet in Protected View. The same is true for any document attached to an email message, or any document in your browser cache.
You can turn off Protected View for any of these options by clicking File / Options / Trust Center / Trust Center Settings… / Protected View.
Experienced users of Microsoft Office already know about the Format Painter, which lets you “paint” formatting from one block of text to another.
PowerPoint 2010 has added an Animation Painter that basically works the same way:
NOTE: Click the Animation Painter once to paint once, and the Animation Painter will turn itself off. Double-click the Animation Painter to paint multiple objects, and click the tool again to turn it off when you are finished painting.
To crop a picture to a shape in PowerPoint 2010:
To view a how-to video on this topic from Microsoft:
Google Analytics Online Workshop
Learn how to use this amazing free tool to find out a wealth of information about the visitors to your website.
Easy to set up and use.
This is a two-part online class with a live instructor using GoToMeeting.
Tips and Tricks