How to Insert Animated GIF Files in Excel

Written by dan howard
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Insert Animated GIF Files in Excel
You can add an animated GIF to an Excel worksheet using the Visual Basic editor. (drawing image by Renata Osinska from Fotolia.com)

Animated graphics interchange format (GIF) image files are simple animated movie files that work by rotating through a single sequence of GIF images. Microsoft Excel allows you to display an animated GIF image that is contained on your hard drive in any Microsoft Excel worksheet. In order to embed an animated GIF file, you'll need to know the full location and name of your GIF file, and you'll need to insert a snippet of virtual basic code into your Excel spreadsheet.

Skill level:
Moderate

Other People Are Reading

Instructions

  1. 1

    Navigate to the folder that contains your animated GIF file. Write down the full path name of the folder and the name of the file. For example, if the file is contained in a subfolder of your C: drive called Pictures and the file name is bear.gif, then the full path name would be c:\pictures\bear.gif.

  2. 2

    Open the Microsoft Excel document to which you would like to add your animated GIF.

  3. 3

    Click on the "View" menu and choose "Toolbars" => "Control Toolbox."

  4. 4

    Click on the top button in the "Control Toolbox," which activates "Design Mode." "Design Mode" allows you to draw an item in your spreadsheet that may receive an object such as an animated GIF.

  5. 5

    Click on the bottom button in the "Control Toolbox," which has a hammer. From the drop-down menu, select "Microsoft Web Browser." This activates "Microsoft Web Browser" controls, which can be used to view animated GIFs.

  6. 6

    Left-click and hold down your mouse button on the location in your spreadsheet in which you would like to embed the animated GIF. Draw a box that is large enough to contain the animated GIF image.

  7. 7

    Click on the "Design Mode" button again to disable design mode. Close the "Control Toolbox" toolbar.

  8. 8

    Hold down the "Alt" key on your keyboard and press the "F11" key. Doing so will open a Microsoft Visual Basic window within Excel.

  9. 9

    Double-click on the worksheet to which you are adding your animated GIF in the Project list in the upper-left corner of the Visual Basic window. This will open a Visual Basic Code window.

  10. 10

    Copy and paste the following code into the Code window:

    Private Sub Worksheet_Activate()

    WebBrowser1.Navigate "C:\pictures\bear.GIF"
    

    End Sub

    Change the path name and filename in quotes to the appropriate path for your animated GIF file.

  11. 11

    Click to a different worksheet, and then click back to the worksheet to which you added the GIF. The animated GIF should be visible in the object box that you drew.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.