See all products »
Curah! curation service
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Server and Tools Blogs
TechNet Flash Newsletter
Cloud and Datacenter
Windows Server 2012 R2
System Center 2012 R2
Microsoft SQL Server 2012 SP1
Windows 8.1 Enterprise
See all trials »
Microsoft Download Center
TechNet Evaluation Center
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
MCSA: Windows 8
Windows Server Certification (MCSE)
Private Cloud Certification (MCSE)
SQL Server Certification (MCSE)
Second shot for certification
Born To Learn blog
Find technical communities in your area
For small and midsize businesses
For IT professionals
For technical support
For home users
Microsoft Premier Online
Microsoft Fix It Center
Security Bulletins & Advisories
International support solutions
Log a support ticket
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
The Productivity Hub
Office for Mac 2011
Browse by Tags
The Productivity Hub
Casual Friday: Use OneNote TripBooks to help plan your vacation
The OneNote team invited 40 travel bloggers to create OneNote documents covering major travel destinations. You can preview them online via SkyDrive and then download local copies to customize in OneNote 2010. Download the free OneNote TripBooks and then make them your own by adding your specific vacation...
3 Jun 2011
Publish your Access database to SharePoint
If you have an Access database sitting on your hard drive that you want to share with a larger team, one of the quickest and most flexible options is to publish it to a SharePoint site using Access Services. If you don't already have a database, you can quickly create one from a template. In Access 2010...
8 Nov 2010
Formula Watch - Convert numbers to and from Roman numerals
Once you get past 20 or so, converting Roman numerals to Arabic (or vice versa) can be tricky. But you can save time and improve accuracy with a pair of Excel functions. To convert an Arabic number to its classic Roman numeral, use: =ROMAN(A1) Naturally, you can place a number directly into the parentheses...
1 Mar 2011
Add impact to your Word documents with Text Effects
Have you ever noticed that glowing button on your ribbon in Word 2010? It’s the gateway to a number of Text Effects that you can use to dress up your documents: Let’s say you’re making a flier for the company picnic. A nice bright sunny theme might brighten things up! Select a suitable style (like the...
21 Jan 2011
Restrict data entry in Excel with lists
I recently shared how you can restrict data input in Excel to certain number ranges , such as whole number percentages. But what if you're dealing with a strict set of values, like product names, and you don't want users to be able to create any new variations when entering data? That's easy to do too...
9 Jun 2011
Add more social network connections to Outlook 2010
Two more social networks have been released for Outlook 2010. You can now add Outlook Social Connector support for Facebook and Windows Live Messenger in addition to the LinkedIn and MySpace plug-ins that were released previously. Once you've entered your credentials for each service, you can quickly...
23 Aug 2010
Print Excel table headers on every page
If you're printing a long spreadsheet in Excel and want to have the same header row across the top of each page, you're in luck. There's a little-known feature tucked away in Excel 2007 and Excel 2010 to do just that. If you're using Excel 2007, go to File , Page Setup and then open the last tab. In...
10 Nov 2010
Move paragraphs up and down quickly in Word
The numbered sort technique is useful when you need to carefully plot the restructuring of a long, complex document. But what if you just want to quickly move a paragraph or two up or down? No problem. First select any paragraphs you want to move, hold down both the Shift and Alt keys and then tap either...
14 Dec 2010
Link your PowerPoint presentations to improve flow
You know that awkward pause during team presentations when one team member hands off to another, and there is much squabbling to bring up the correct presentation? That's because most people don't realize you can easily link slide decks to each other - as long as they're locked down at least a little...
10 Feb 2011
Remove formatting, hyperlinks, and comments in Excel
Clearing out cells of font mismatches, fill colors, hyperlinks, comments, and conditional formatting doesn't have to be tedious. There's a much easier way. First select the cells you want to clear. In Excel 2007, you need to go to the Edit menu and select the Clear command to access Clear Formats . In...
18 Nov 2010
Correct mistakes using Print Preview Edit Mode in Word 2010
If you find you spend a lot of time switching between editing and the default print preview in the Print pane, Word 2010 has a hidden Print Preview Edit Mode you should try. First, you'll need to add it to the Quick Access Toolbar so you can find it quickly when you need it. Click the down arrow next...
18 Apr 2011
Make your Excel rows and columns consistent
As you enter data into cells in your Excel worksheet, you may notice that your rows change height - which can lead to a sloppy presentation if you're sharing the data. Likewise, you may want to adjust your column widths to make them more consistent. There's a quick way to do this. Simply select and right...
17 Feb 2011
Casual Friday: Make PowerPoint the life of the party
Whether you're throwing a company party, wedding, shower, or birthday bash, PowerPoint can add life to the event. Fill a slide deck with photos culled from a year of work events or a lifetime of memorable activities and creatively arrange them in a slide deck. You can even add movies: Just go to the...
8 Oct 2010
Formula Watch: Working with week numbers
There are plenty of scenarios where you'd want to know the week number within a year. Say you are developing a schedule with a time budget, and you need to know how many hours you can commit per week over the course of a project or fiscal year. Or maybe you just want to know how many weeks are left until...
28 Sep 2010
Get the new Outlook Hotmail Connector
If you use the Outlook Hotmail Connector, you may have already been prompted to update to the new version: This version 14.2 update corrects a number of sync issues, improves performance, and turns off the junk mail filter in Outlook in favor or Hotmail's own filtering system. If you've made entries...
16 May 2011
Casual Friday - Track World Cup soccer in Excel
This week, I'm introducing a new occasional feature: Casual Friday. In it, I'll share uses for the Office applications that we've all put to such good use being productive at work to enrich our personal lives as well. I recently found just such a use over at the Microsoft Excel blog, where they've released...
11 Jun 2010
Customize and backup your Office 2010 ribbons
If you are a fan of the Office Ribbon, you have an unprecedented amount of control over it in Office 2010. If the default Ribbon doesn't offer up your favorite commands, you can simply create custom tabs and groups to easily access your favorite features. To ensure a base level of consistency, you cannot...
12 Aug 2010
Compare and merge slides in PowerPoint 2010
One of the little trumpeted but extremely valuable features in PowerPoint 2010 is the ability to compare and merge slides from separate decks. To use this feature, first open your main presentation file and go to the Review tab. Click the Compare button: Select the file you wish to compare it with and...
31 May 2011
Set your own default reminder alert time in Outlook
If you're like me, you like to be prepared for your meetings. This can mean extra time for reviewing documents, brainstorming ideas, and printing handouts - not to mention travel time. If you're frequently late or unprepared for your appointments, simply change the default reminder. Go into File , Options...
17 May 2011
Print just one page in Outlook 2010
Have you ever wanted to print just the first page of an email message? Most of the time, right? You may not realize it, but there is a place to select this in Outlook 2010. Just go to File , Print (or press Ctrl-P) and then click Print Options : Directly below the Print style box, about halfway down...
14 Feb 2011
Writing a good Out of Office message (and how to set it)
When you're on vacation or holiday, it's wise to set an Out of Office message (abbreviated as OOF). Here are some tips to writing a good one: Provide the dates that you are unavailable. If it's only a partial day, provide the time you expect to be back on mail. Describe whether you will have limited...
27 Dec 2010
Publisher Has Your Back
Designing is a tricky business. One forgotten element—like half a logo hanging off the front page of my company newsletter—can be endlessly embarrassing, for me and my company. I’ve learned to double- and triple-check for problems before I distribute a file from Microsoft Office Publisher...
2 Aug 2012
Save all open Word documents at once
The Save All command used to be a hidden feature of Microsoft Word, unlocked by holding the Shift key while selecting the File menu. But this won't work in recent versions of Word. Fortunately, it's easy to add to your Quick Access Toolbar. Go to Word Options ( under the File menu in Word 2010 and the...
24 Mar 2011
Changing case in Excel
If you had to choose a program to use for changing case (UPPERCASE, lowercase, Sentence case, etc.) Microsoft Word works best in most cases. It has several options available, and the changes you make are retained if you copy and paste them. But Excel can be useful at this task too, if you understand...
21 Dec 2010
Force recipients to Reply All in Outlook
Have you ever sent a mail and asked that recipients use Reply All, only to have some people respond just to you? Then YOU have to forward the mail to the rest of the group. Thankfully, there is a way to force Outlook to send replies to a specific list of recipients regardless of whether they click Reply...
11 Apr 2011
© 2015 Microsoft Corporation.
Privacy & Cookies