Quick Tips
- You can save a specific image from your Excel workbook by right-clicking on the image and selecting Save as Picture.
- You can also copy specific images from your Excel workbook and paste them elsewhere.
- If you want to extract all the images from your Excel file at once, save the workbook as a web page.
Method 1: Save Individual Images Manually
The most straightforward way to extract images from an Excel workbook is to save them manually. Here’s how to go about it.
Step 1: Open your Microsoft Excel workbook > right-click on the image you want to get > select Save as Picture.
Step 2: In the Save As Picture window, navigate to the folder where you want to save the image. Name the image and select your preferred file format. Then, click Save.
Method 2: Copy the Image and Paste It Elsewhere
You can also copy an image from your Excel workbook and paste it into another program. To do so, right-click on an image in your Excel workbook and select Copy.
After that, switch to the app where you want to insert the image and paste it. This method will allow you to export images from your Excel file to Word, Gmail, WhatsApp, and so on.
Method 3: Save Your Excel File as a Web Page
Although the above two methods are straightforward, they aren’t the most efficient for extracting multiple images from an Excel file.
So, if you want to extract all the images from your Excel file at once, you can save it as a web page. Here’s how:
Step 1: In your Excel workbook, click the File menu at the top-left corner.
Step 2: Select Save As from the left sidebar.
Step 3: Select a location to save your file and enter a name for it. Then, use the drop-down menu to select Web Page from the list.
Step 4: Click the Save button.
Step 5: Navigate to the folder where you saved your Excel file as a web page and you’ll see a folder with the same name as your Excel file.
Step 6: Open the folder to view all the images from your Excel workbook.
Method 4: Add ZIP Extension and Extract the File
Another method for saving all the images from an Excel workbook is to convert it to a ZIP file and extract it. Here’s how to go about it.
Step 1: On your PC, locate and select the Excel file containing the images. Then, press F2 to rename it.
Step 2: Change the file extension from .XLSX to .ZIP and select Yes when prompted.
Step 3: Right-click on the renamed file > select Extract All.
Step 4: Use the Browse button to select a location where you want to extract the file and click Extract.
Step 5: Navigate to the folder where you extracted the file and double-click the xl folder within it.
Step 6: Open the folder named media and you’ll find all the images that were there in the Excel workbook.
Was this helpful?
.happy-face-cls-1{fill:#c9c9c9;}.happy-face-cls-2{fill:#e1e1e1;}.happy-face-cls-3{fill:#676767;}
.sad-face-cls-1{fill:#c9c9c9;}.sad-face-cls-2{fill:#676767;}.sad-face-cls-3{fill:#e1e1e1;}.sad-face-cls-4{fill:#676767;}
Thanks for your feedback!
Categories: How to
Source: thpttranhungdao.edu.vn/en/