bottom
Great ExcelTips!
         
Your e-mail address is safe!
Close Note

Tips.Net > ExcelTips Home > Tools > Inserting a Voice Annotation in Your Worksheet

Inserting a Voice Annotation in Your Worksheet

Summary: Adding audio notes to a workbook is easy to do in Windows. This tip explains how you can record an audio file for saving with a worksheet, and then play the file again at a later time. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

Rather than adding notes to the cells in your worksheets, you can imbed audio files that serve as audible annotations. In order to do this, you must have a sound board which is supported by Windows, along with a microphone. Then you can follow these steps:

  1. Position the insertion point where you want the message inserted.
  2. Choose Object from the Insert menu. You will see the Object dialog box.
  3. Make sure the Create New tab is selected. (Click here to see a related figure.)
  4. In the list of object types, look for a type of sound object. It may have a name such as Sound or Wave Sound. Select this option.
  5. Click on OK. The Sound Recorder (a Windows accessory) will be displayed. (Click here to see a related figure.)
  6. Use the Sound Recorder to record your message.
  7. Close the Sound Recorder window.
  8. You may be asked if you want to update your workbook. If so, then click on Yes.
  9. An icon of a speaker appears in your workbook where the sound is inserted.

You can later listen to your message by simply double-clicking on the speaker icon.

Tip #2870 applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003


PivotTables Got You Perplexed? ExcelTips: PivotTables for the Faint of Heart shows how you can start using Excel's PivotTable tool right away to spin your data into gold! You discover how easy it really is to crunch the numbers you need to crunch. Uncover the power of the PivotTable Wizard, how to edit PivotTables, how to format them, how to customize them, and much more.
 
Check out ExcelTips: PivotTables for the Faint of Heart today!

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home
Vital News Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

 

Great Info!

Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)