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, 2022 in Others by Kithuzzz
• 38,010 points
455 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, 2022 by narikkadan
• 63,700 points

Related Questions In Others

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, 2022 in Others by narikkadan
• 63,700 points
832 views
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, 2022 in Others by narikkadan
• 63,700 points
545 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, 2022 in Others by narikkadan
• 63,700 points
565 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, 2022 in Others by narikkadan
• 63,700 points
555 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, 2022 in Others by narikkadan
• 63,700 points
520 views
0 votes
1 answer

Add .xll as AddIn to Excel

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

answered Feb 17, 2022 in Others by gaurav
• 23,260 points
1,025 views
0 votes
0 answers

MS Excel - SumProduct formula with Loop

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

Feb 18, 2022 in Others by Edureka
• 13,670 points
298 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, 2022 in Others by narikkadan
• 63,700 points
480 views
0 votes
1 answer

How to trick an Excel function that wants a column as input to accept a list of values as if these were in a column

Use VSTACK: vstack to make an array: Use it as value ...READ MORE

answered Mar 18, 2023 in Others by narikkadan
• 63,700 points
336 views
0 votes
1 answer

Excel-VBA - How to identify Target range (more than 1 cell) is deleted in a Worksheet_Change function?

You misunderstand the purpose of the function ...READ MORE

answered Sep 23, 2022 in Others by narikkadan
• 63,700 points
3,277 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