[December 2007 ]
Merry Christmas everyone! I know that not everyone celebrates Christmas but I do and I would like to share it with each and every one of my subscribers. I wouldn't try to change anyone's beliefs, I just want you to feel the warmth and happiness of the season as I do. Please have a wonderful holiday whatever your persuasion might be. Appreciate your families and friends and take a moment to think of those who have no family with them at this time of year.
I want you all to know that because of subscriptions and books sales, I was able to double my monthly donation to The Covenant House. That means that no matter how many children show up at the shelter on Christmas eve, they will have a warm, clean place to sleep and a meal with people who care about them. In other words, they will not be alone on Christmas. They will receive the gift of hope and caring. For that I thank you from the bottom of my heart!
May you all have a Merry Christmas and a healthy, happy and prosperous New year!
Table of Contents
Auditing Errors in MS Excel - Track those errors down!
Insert an E-Mail Address into a Slide in MS PowerPoint - Get your name out there!
Set a Language To A Style in MS Word - No more spelling errors!
Auditing Errors in MS Excel
I hate it when an error message shows up in my Excel spreadsheets! Doesn't everyone? When you see an error message it generally means that somehow, somewhere, a typo has made its way into one of your formulas or a piece of information is either incorrect or missing.
If you were the author of the formula that is returning the error, you may not have too much difficulty in determining where the trouble is located. However, if you are working in someone else's spreadsheet it may not be as easy to spot that error. That is when you use the Auditing Tools in MS Excel to sniff out the cause of the error.
Follow the steps below:
- Click on the cell that contains the error message to select it.
- Click on Tools | Auditing | Trace Error.
When you do this, Excel will draw an arrow to the cell that contains the error, from every cell that the formula references.
You can then see at a glance which cells you need to audit to confirm that they contain the correct information.
After you have audited the problem, remove the arrows by following the instructions below:
- Click on Tools | Auditing | Remove All Arrows.
Insert an E-Mail Address into your Slide in PowerPoint
You want your audience to remember who you are and how to get in touch with you, once your presentation is finished. One way to do that is to include your e-mail address in your presentation that you hand out to your audience.
Follow the steps below to learn how:
- Open your PowerPoint presentation.
- Select the object, text or shape to which you wish to assign the e-mail link.
- Right-click the object and select Action Settings from the menu.
- The Action Settings dialog box appears.
- Click Hyperlink to:
- Select URL... from the drop-down list.
- Enter your e-mail address into the text box using the format below:
mailto:your_email_address@yourdomain.com
- Replace your_email_address with your actual e-mail address, and yourdomain.com with the domain name of the e-mail address.
That's all there is to it and when they play your presentation they can simply click the link to get in touch with you via e-mail.
Set a Language Style in MS Word
When you enter text into your Word document that is something other than English, chances are that MS Word will not recognize it and will interpret it as being misspelled.
If it is necessary for you to have sections of non-English text within your English-language Word documents, then you know how annoying it is when Word checks the spelling of the non-English text using its English dictionary.
Word is programmed to automatically proofread your document for the language version that is installed on your computer. If you purchased your licensed copy of MS Word in the United States, your text will all be marked as English (U.S.) and Word will proof non-English text against the English (U.S.) dictionary.
When you add text in a language other than English (U.S.), Word's spelling and grammar checker will flag them as being misspelled. To let Word know which dictionary to use to proof the text, you should mark it for proofing in its own language by assigning a language style.
Follow the steps below to learn how:
- Key in the foreign language text.
- Select the text.
- Go to Tools | Language | Set Language.
- Scroll ot and select the language from the Mark Selected Text As list.
- Click OK.
- Go to View | Task Pane.
- Click the Getting Started arrow and select Styles And Formatting from the list.
- With the text still selected, click New Style.
- Enter a name for the style (such as Spanish) in the Name box.
- Click OK.
Now, when you want Word to proof your text in Spanish, simply highlight the text and select Spanish from the drop-down Style box in the Formatting toolbar. This new style will be available to the current document only. If you want it to be available to the template the document is based on, click the Add To Template check box in the New Style dialog box after step 9 before clicking OK.
Included in the Premium Newsletter:
- Change the Angle Or Orientation of Text in Excel 2007
- Using Negative Indents in MS Word
- Record Document Properties in MS Word
- Printing your Document in MS Word
- Embed a Sound in MS PowerPoint
- Change Page Orientation to Landscape in MS Word
- Carol's Corner Office members receive the premium edition of the Word Bytes Newsletter. To become a member click HERE.