Microsoft Office tips

In a comment on my last post, cdotspace asked about how to keep Microsoft Word 2007 from crashing. When I had this problem, I solved it by starting Word with no add-ons, and then enabling the add-ons one at a time until the problem recurred. I removed the troublemaker, which was actually a macro of my own poor devising, and no more crashes.

That got me thinking about how difficult it is to figure out the cause of application crashes. Back in March, I described ways to diagnose applications that won't close properly. But when it comes to finding … Read more

What I really want to do is add a link to Google Docs on the right-click (context) menu in Windows Explorer. That way, I could open a file in Google Docs by right-clicking it in Explorer and choosing Send To > Google Docs.

Well, I wasn't able to figure out how to do this. So instead, I created a shortcut to open Google Docs, and then I browsed to the file and opened it the old-fashioned way.

This won't save you a lot of time, but at least Google Docs makes it easy for you to transmit the … Read more

You could create every document, spreadsheet, and presentation you work on from scratch, but if you're like me, you'll likely spend more time futzing with the file's layout and design than entering the data that comprises it.

That's why I rely on the many free templates and extensions for my favorite productivity apps. I've written in the past about places to find add-ons for Microsoft Office, but there's also a wealth of free extensions and templates for OpenOffice.org's Writer word processor, Calc spreadsheet, and Impress presentation program.

Start at OpenOffice.org's … Read more

On Monday, I described Vaita's free Outlook Duplicate Items Remover, an add-on that finds duplicate copies of Outlook messages, contacts, calendar entries, and tasks. Now, I'll continue to trim my bloated Outlook in-box by using another freebie: the Kopf Outlook Attachment Remover created by Bruno Marotta.

After you download the program and restart Outlook, you see a floating Attachment Remover toolbar that you can drag and dock at the top of the screen along with all the other toolbars to keep it from blocking your view. Click the toolbar's one-and-only button to open the program's one-and-only … Read more

Sometimes I wish I was one of those people who manages to keep their e-mail inbox empty by assigning the messages they need to keep appropriately named folders and deleting the mail they don't need.

Most of my inboxes have thousands of entries dating back years. And since I've combined my ISP's POP mail account with my Gmail account, the inbox-overflow problem has gotten out of hand.

Rather than spending half a day manually removing the duplicates, I installed Vaita's free Outlook Duplicate Items Remover. The program places an "ODIR" entry on Outlook's … Read more

Since I tend to reopen files repeatedly, I like Microsoft Office's list of recently used files that appears at the bottom of the File menu in Office 2003 apps, and on the right side of the window that opens when you click the Office button in their 2007 counterparts. (These documents are also accessible via the My Recent Documents button on the left side of Open and Save As dialog boxes in Office 2003.)

What I don't like is the default of four documents that Office 2003 shows on the File menu. Since I'm likely to cycle … Read more

If you create custom AutoCorrect entries to speed up your typing in Microsoft Word as I described on Monday, you might need to move those entries to another PC someday.

Years ago, Dave Rado wrote a Word macro for backing up and restoring the program's AutoCorrect files. It still works for Word 2007--or at least it did on my PC.

First, make sure macros are enabled. In Word 2003, click Tools > Macro > Security > Security Level, and select either of the bottom two options. In Word 2007, click the Office button, choose Word Options > Trust Center &… Read more

If I had a nickel for every time I've typed the word "Microsoft," and another two cents for each occasion I've had to enter "Windows," I just might own the dang company by now.

I'll bet you've got your own list of terms you've typed so often you can barely see the letters on their keys anymore. But there's no need for you to spell them out each time you need to use them. Just enter them once in the AutoCorrect dialog box in Microsoft Word, Excel, PowerPoint, and other … Read more

Microsoft claims that Office 2007's ribbon interface saves time by putting the features people use most often closer at hand. For those of us who spent years learning where those functions were in previous versions of Word, Excel, and PowerPoint, the changes aren't the productivity boosters Microsoft envisioned.

I've done more than my share of rummaging around the ribbon in Office 2007 trying to find a particular command, and I've even used Microsoft's user-interface guides to hunt down the feature I needed. Now Microsoft Office Labs has developed the free Search Commands add-on for Office … Read more