How to Paste JPEG as a gif in excel

0 votes
I have a normal jpeg and I want to paste this as a gif in Microsoft excel, how can I do that? I tried pasting from the insert option and then choosing the image but that's the same thing as copy/paste I think. Please help.
Oct 1 in Others by Kithuzzz
• 20,660 points
54 views

1 answer to this question.

0 votes

Solution 

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.

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

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.

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.

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.

Step 10 Copy and paste the following code into the Code window:

Private Sub Worksheet_Activate()

End Sub

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

Step 11 Click on 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.

answered Oct 2 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

How to get rid of a #value error in Excel?

Changing the format to "Number" doesn't actually ...READ MORE

answered Oct 3 in Others by narikkadan
• 37,660 points
83 views
0 votes
1 answer

How to create a drop-down list in Excel?

Making a list of the items you ...READ MORE

answered Oct 9 in Others by narikkadan
• 37,660 points
61 views
0 votes
1 answer

In Excel, how to find a average from selected cells

If one has the dynamic array formula ...READ MORE

answered Oct 9 in Others by narikkadan
• 37,660 points
60 views
0 votes
1 answer

How to open an Excel Online document as a PDF

In light of your comment above, I ...READ MORE

answered Oct 18 in Others by narikkadan
• 37,660 points
40 views
0 votes
1 answer

How to stick an embedded document in a specific cell of an excel

Solution Select the documents (you can use the ...READ MORE

answered Oct 18 in Others by narikkadan
• 37,660 points
34 views
0 votes
1 answer

Add .xll as AddIn to Excel

Hi, for adding an xll as Addln ...READ MORE

answered Feb 17 in Others by gaurav
• 22,040 points
126 views
0 votes
0 answers

MS Excel - SumProduct formula with Loop

1 I have 4 arrays of data where ...READ MORE

Feb 18 in Others by Edureka
• 13,640 points
83 views
0 votes
1 answer

JavaScript API does not work for Excel 2013?

Each method in the Office.js APIs is ...READ MORE

answered Sep 26 in Others by narikkadan
• 37,660 points
50 views
0 votes
1 answer
0 votes
1 answer

How to create a drop-down in excel with custom values

You can accomplish that using code rather ...READ MORE

answered Sep 25 in Others by narikkadan
• 37,660 points
68 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP