Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Help and How-to
Search
Search
 
Check for updates: (c) Microsoft
Microsoft Update
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
10 Office features you need to know about
 
Crabby Office Lady: (c) Microsoft

Crabby Office Lady

Some things we just can't do without in life: love, friendship, a bathroom door that locks. With Office, the same is true: Some features should not be overlooked.


Subscribe to Crabby's columns
Read all the Crabby Office Lady columns
Get the Crabby Office Lady's book

One of the complaints we get around here is that some of these programs have so many features that you can't figure out which ones would be the most useful for you. This week I'll clue you into some of favorites.

Feature #1: The editor inside the box: Use the Spelling checker

... especially if you're writing to me! If I've said it once, I've said it 100 times: Please, if you're sending e-mail, writing a letter, or creating a Web site, please make use of the spelling checker. Either turn on this feature so that it automatically notifies you when you've misspelled a word, or press F7 to launch the spelling checker yourself before you've completed your task. It's simple, it's quick, and it's the courteous thing to do.

More information about the spell checker

Office 2007

Office 2003

And before I forget, Word 2007 has this fabulous new feature: Instead of just giving you the squiggly read line to indicate a spelling error a green squiggly line for a grammar error, Word 2007 introduced a new member of this flagging community: The blue squiggly line. It flags words that are likely inappropriate, considering their content. Interested in finding out more? Read program manager Jonathan Bailor's Office Hours column The next generation of the spell checker.

Feature #2: Say it, don't spray it: The Bcc box

Now this one I KNOW I've mentioned before. Bcc is an abbreviation for blind carbon copy. If you add a recipient's name to this box in an e-mail, a copy of the message is sent to that recipient, and the recipient's name is not visible to other recipients of the message. Consider using the Bcc box when:

  • You want your mailing list to remain private.
  • You want to protect your recipients from possibly getting on a spammer's list. Consider this: If you send out a message to 10 people (and you don't put their e-mail addresses in the Bcc: box), if each of those 10 people forwards it to 10 other people, and if each of those 100 people forwards it to 10 more people, your original 10 e-mail addresses are now available to 10,000 strangers. (This is how a version of that "six degrees of Kevin Bacon" game gets started.) Chances are pretty good that one of those 10,000 recipients is a spammer.

Of course, there are other reasons to use the Bcc box, but I'll leave you and your sneaky mind to come up with those.

More information about the Bcc box

Feature #3: I came, I saw, I rewrote: Revision marks

Writers and editors have to work together; it's a law of nature, like gravity or a feeling territorial about a parking space. Using revision marks in Word is one way to keep track of all the changes — agreed upon or otherwise —  that you, as a writer or a reviewer, talk about as a document is written. Using Word's built-in reviewing tools, such as comments or tracked changes, is a lot easier than getting out the red pen or using strikethrough formatting (or whatever). Make use of this handy feature; it really facilitates the reviewing process.

More information about revision marks

And listen, while some of you Word 2003 and Word 2002 users prefer the way Word 2000 handled revision marks (no balloons, just strikethrough formatting for deletions and underlining for insertions) you can set up your version of Word to use the Word 2000 style of revision marks:

  1. On the Tools menu, click Options, and then click the Track Changes tab.
  2. In the Use Balloons (Print and Web Layout) box, select either Never or Only for comments/formatting.

     Note    In Word 2002, clear the Use balloons in Print and Web Layout check box.

Feature #4: Get yourself some insurance: Protect your work

Security is a big word these days, and you'd be wise to pay attention. There are many aspects to computer security, and being who I am, I'm here to encourage you to make your Office documents as secure as you can. Some of the ways you can do this are to password-protect your documents, presentations and spreadsheets; lock your shapes in Visio and prevent changes to files; protect your InfoPath form designs; and Receive Microsoft Technical Security Notifications (via e-mail, RSS, or Windows Live Alerts).

I'm not going to say that security is a simple, straight-forward topic; it isn't. But if you read the information we have out there and follow some of our guidelines, you can rest assured that your Office documents will be a lot more secure than if you just close your eyes and hope for the best.

More information about Office security

Feature #5: I know what I mean: AutoCorrect

This is one handy feature that I use a lot, and I use it in two ways:

  1. I type "Crabby Office Lady" a lot; all day long, in fact. But since I've created an AutoCorrect entry for it, all I have to do is type "COL" and my Office program detects what I really mean and fills in the full phrase for me.
  2. I can also use AutoCorrect to automatically detect and correct typos, misspelled words, grammatical errors, and incorrect capitalization. See, I tend to type fast and quite erroneously. I often type "teh" instead of "the" and "nac" instead of "can." Since I've set up the AutoCorrect to note that, it changes the words back to what they should be. Does this make me lazy? Perhaps. But it saves me time, too.

More information about AutoCorrect

Feature #6: Help me, I'm drowning: AutoArchive

Your mailbox is growing and growing ... and growing. You need a place to store all those items that you can't delete but don't need on a daily basis, and you need a way to do it automatically. AutoArchive in Outlook is the way to handle it. It's on by default and runs automatically at scheduled intervals, clearing out old and expired items from folders. Old items are those that reach the archiving age you specify. Expired items are mail and meeting items whose content is no longer valid after a certain date, such as a meeting you had four months ago that still appears on your calendar. I like to think of it as spring cleaning, but it's easier and can happen more frequently, at any interval you desire.

More information about AutoArchive

Feature #7: Decorating made simple: The Format Painter

The Format Painter, Format Painter button is one of the most handy little features I know. It's a way to copy any formatting you want to duplicate: fonts, shading, borders, and more.

You basically select the text that you want to copy, click the Format Painter button and then select the text to which you want to apply formatting. If you want to apply the same formatting to more than one item, select the formatting you want, double-click Format Painter, and then select each word, phrase, or paragraph you want to apply formatting to. When you're finished, press ESC. No guessing, no multiple steps, and you can use the Format Painter in just about any Office program.

More information about the format painter

Feature #8: Leverage someone else's work: Use a template

When time is of the essence (and when is it not?), no one is a better friend to you than a template. In a nutshell, a template is a pre-designed document, spreadsheet, presentation or any other type of Office document that's been created by a template elf. It has all the colors, layouts, bullets, fonts, and whatever else you want to make your Office document sparkle. All you have to do is plug in your content and away you go. A template saves you the burden of having research and design skills, and it saves us the burden of reminding you that you need to brush up on your research and design skills.

More information about using Office templates

Feature #9: Show, don't just tell: Use some Clip art

I often get e-mails from folks asking me if they can use the clip art on our site for their documents, spreadsheets, e-mail signatures, etc. People: If it's on our site, you can use it. Why would we have it there? Just to tempt you? Yes, use our clip art for all your artistic (and I do realize tha's a broad term) needs!

More information about using clip art

Feature #10: Say it loud, say it proud: Give feedback

I know: You think we're not listening, that we just make these products year after year, without thinking about you or your needs. That just isn't true. In fact, some of us spend a majority of our time listening to you and your ideas. But we can't listen if you're not talking. So please, make the effort and tell us what you like, what you don't like, and what you wish you could have.

More information about saying it loud, saying it proud

All praise the tip of the month

A lot of great people, inventions, and ideas have come out of the Peach State, Georgia:

  • Jackie Robinson, the first Africa American baseball player in the major leagues, was born in Cairo, Georgia.
  • Author, Pulitzer Prize winner ("The Color Purple) and civil rights activist Alice Walker came from Eatonton, Georgia.
  • Juliet Gordon Low got her first taste of thin mints in Savannah, Georgia, and went on to become the founder of Girl Scouts.
  • Misty Kush, working from Norcross, Georgia noticed a tiny little icon in Word that ended up saving her time and irritation:

    Hey there Crabby!! I'm fairly new to Word…and in all the training and classes no one showed me this little tip:

    When you Click the Office Button, the documents you were working on most recently show up under Recent Documents. What I didn't know, until a short time ago, was that if you click the push pin to the right of the name of the document, it "pins" that document to your recent documents so that it always shows up. What a find!! This is great for forms and documents that you need often. I work in accounting, and we use a lot of check requisition forms and form letters that are connected to databases.

Right you are Misty! That is a great find. So, in other words, YOU have control over what's in that Recent Documents list.

 Note   Recent Documents, the display of the last few files you opened in that program appears from the Office Button Office button image in Office 2007 versions of Access, Excel, InfoPath, PowerPoint, Visio, and Word. Push pin imageThe adorable push pin that Misty is talking about is only available in Access, Excel, PowerPoint, and Word. When a document has been pinned to the Recent Documents list, the pin button looks like a push pin viewed from the top. Push pin  image

"A human being has a natural desire to have more of a good thing than he needs." — Mark Twain

About the author

Annik Stahl, the Crabby Office Lady columnist, takes all of your complaints, compliments, and knee-jerk reactions to heart. Therefore, she graciously asks that you let her know whether this column was useful to you — or not — by entering your feedback using the Was this information helpful? tool below. And remember: If you don't vote, you can't complain.

Subscribe to Crabby's columns
Read all the Crabby Office Lady columns
Get the Crabby Office Lady's book
Get Office 2007
Get Office 2007
advertisement