Excel.Tips.Net Welcome toExcel.Tips.Net

Helpful Links

Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment

Tips.Net Store

ExcelTips FAQ
ExcelTips Premium

Learn Access Now
Free Printable Forms

Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

Newest Tips

Recording a Macro

Adding a Little Animation to Your Life

Converting a Range of URLs to Hyperlinks

Making the Formula Bar Persistent

Engineering Calculations

Digital Signatures for Macros

Fixing the Decimal Point

 

Inserting a Sound File in Your Worksheet

Summary: Excel allows you to insert all types of objects in your worksheets, including audio files. This tip explains how to insert an existing audio file in a worksheet, and then how to use that audio file at a later time. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

If you are the type that likes to give your workbooks a slant toward multimedia, Excel allows you to insert sound files in your worksheets. This is done in this manner:

  1. Select the cell near which you want the sound inserted.
  2. Choose Object from the Insert menu. You will see the Object dialog box.
  3. Click on the Create from File tab.
  4. Use the controls on the dialog box to locate a sound file that you want included with your document.
  5. Click on OK. An icon that looks like a speaker is inserted in your document.

You can later listen to your sound file by simply double-clicking on the speaker icon. You can also move the icon to some other place on your worksheet, as it appears to "float" over the actual contents of the worksheet. Simply click on the icon once, and use the mouse to drag it to a new location.

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

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!