[Excel Efficiency] Taking screenshots → inserting with Excel only! A technique for quickly creating operating instructions with images

I want to paste a screenshot into a sheet

Have you ever wanted to insert a screenshot of the screen while creating an operation manual in Excel? Also, there may be times when you want to capture and insert a map you searched for on the internet into materials such as invitations.

In Excel, the "screenshot function" was added from Excel 2010, making it possible to easily insert a screenshot of the window into the sheet without using a capture tool or the like.

This time, I will explain the screenshot function of Excel. It saves you the trouble of switching windows and activating other tools, so you can improve your work efficiency.

As an example, let's consider how to use the spell check function of Word and create an operation manual in Excel.

　In order to create an easy-to-understand operation manual, it is common to want to paste screen shots as part of the operation instructions (①).

Therefore, let's insert a screenshot of the screen where the Word document is open in the Excel operation manual.

With the location where you want to insert the image (here, cell A4) (②) selected, click the [Insert] tab (③) → [Take a screenshot] (④) to display the [Available windows] ( ⑤) is displayed. Available Windows displays a list of currently open windows. Select the window (⑥) you want to insert from this list.

Then, a screenshot of the selected window was inserted into the Excel procedure (⑦).

When editing is finished by adjusting the size of the inserted image and adding a frame around it (⑧), the operation manual is complete.

With this method, there is no need to use a capture tool. Also, you don't have to switch windows while working. It's a convenient function because it can be used easily when you want to capture a small screen.

However, there are points to note when using this function. First, you need to have the window of the application you want to capture open beforehand. Otherwise, it will not appear in the Available Windows list. Also, windows minimized to the taskbar cannot be captured.

Have you ever wanted to paste a map you found on the internet when creating an invitation for an event? Now consider the example of inserting a map found on the Internet into an invitation to an annual meeting.

　As a prerequisite, the map page you want to paste must be at the top of the open applications (except Excel). This means that the map page must be displayed just before pasting the map.

With the location where you want to insert the image (here, cell A9) (①) selected, select the [Insert] tab (②) → [Take a screenshot] (③) → [Screen area] (④) Click

　The screen will switch to the map page. The overall screen becomes whitish, and the mouse pointer is displayed as a cross (⑤).

　Drag (⑥) the area you want to cut on the map page.

When the mouse is released, the screen switches to the Excel screen and the map of the cut area is inserted (⑦).

The image is reduced to an appropriate size and completed (⑧).

This time, I explained the screenshot function that became available from Excel 2010.

It is an easy-to-use and convenient function that saves you the trouble of switching windows and starting the capture tool. If you want to paste a screenshot into an Excel sheet, please try it.