How to Insert Animated GIF Files in Excel

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.
You can add an animated GIF to an Excel worksheet using the Visual Basic editor.

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.

Advertisement

Step 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.

Advertisement

Video of the Day

Step 2

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

Step 3

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

Advertisement

Step 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.

Step 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.

Advertisement

Step 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.

Step 7

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

Advertisement

Advertisement

Step 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.

Step 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.

Advertisement

Step 10

Copy and paste the following code into the Code window:

Private Sub Worksheet_Activate()

End Sub

Advertisement

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

Step 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.

Video of the Day

Advertisement

Advertisement

references