This time, we will introduce various methods of pasting image data such as photos and illustrations in Excel. We will check how to easily insert image files saved on your PC, images on the Internet, captured images on your PC, etc.
If you want to effectively display a table created in Excel, we recommend pasting an image (figure) file such as a photo or illustration onto the sheet. This time, we will check how to easily insert image files saved on your PC, image files and icons on the Internet, and captured images of windows displayed on your PC.
In this series, we will explain how to use Office applications based on the key words, "Frequently used but easy to forget Microsoft Office operations". The article is produced using Microsoft Office 2016, which has been updated to the latest state at the time of writing.
Paste an image file saved on your PC
First, check how to insert image data such as photos, illustrations, and logos saved on your PC storage into an Excel sheet. will do. Start with the ribbon on the Insert tab.
Paste an image from the Internet (online)
I want to insert an image according to the table to be created, but I do not have the image file at hand. In such a case, find an image that can be used without problems from the Internet and paste it. Click on the "Pictures" icon on the "Insert" tab and click "Online Images" to browse through various categories of images that you may be able to use. If you use "Creative Commons" images that allow third parties to use them, you can rest assured in terms of copyright, but please be aware that there are cases where problems may occur depending on the purpose and usage.
Use Icons to Emphasize Table Content
If you don't need a large image, but want to include a quick picture to make the table easier to understand, try inserting an icon. let's If you select "Icon" from the "Illustration" icon on the [Insert] tab, you can check a wide variety of icons that can be used for both business and personal use. The inserted icon can be customized by changing the color and adjusting the size, and can be used as an item to emphasize the contents of the table.
Capturing and pasting the window
There are many cases where you want to paste the page displayed in the web browser as an image. Excel is equipped with a screenshot insertion function, and you can execute a series of operations from screen capture to pasting to a sheet. It is convenient to remember because it is easier than the method of capturing the browser screen one by one and saving it on the PC and then inserting it.
Capture and paste only a part of the screen
If you use Excel to create a PC operation manual, capture only a part of the Windows desktop screen. It is convenient if you can paste it on the sheet by Excel's "Screenshot" screen has a menu called "Screen area", and when you select this, you can select and cut out any part of the desktop screen and paste it on the sheet. This is a useful function when you want to use only a part of the displayed web page, so let's remember this as well.