Loading
Excel.Tips.Net ExcelTips (Menu Interface)

Inserting a Voice Annotation in Your Worksheet

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, your computer must have sound capabilities (either built-in or through an added sound board) which are 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. (See Figure 1.)
  4. Figure 1. The Create New tab of the Object dialog box.

  5. 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.
  6. Click on OK. The Sound Recorder (a Windows accessory) is displayed.
  7. Use the Sound Recorder to record your message.
  8. Close the Sound Recorder window.
  9. You may be asked if you want to update your workbook. If so, then click on Yes.
  10. 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.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2870) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Related Tips:

PivotTables Got You Perplexed? 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 creating PivotTables, editing them, formatting them, customizing them, and much more. Check out PivotTables for the Faint of Heart today!

 

Comments for this tip:

Paul    31 Jan 2012, 14:48
Wow, using 2003 Excel, great ! The audio tool limits to 60 seconds but very do-able !!
Gary Lundblad    31 Jan 2012, 10:09
I don't see a sound or wave sound object. I am using Excel 2007. This is a tip I would like to take advantage of, but I don't see the object you are referring to.

Thank you,

Gary Lundblad

Leave your own comment:

*Name:
Email:
  Notify me about new comments for this tip
Hide my email address
*Text:
*What is 2+3? (To prevent automated submissions and spam.)