How do I insert an image into an Excel Comment Box. Insert Picture into a Comment; Video: Insert Picture into a Comment; Insert Picture into a Comment. Assuming that you have created some comments in your current worksheet. And you want to insert a picture into comment box, it can be more insightful for your comments. How to achieve it. Insert picture into excel cell [closed]. And I have just tried the insert image, and special paste. You can add the image into a comment.
In Office 2011 for Mac, Excel’s simple Paste option handles most of your ordinary pasting requirements, but it’s a one-shot deal — you can choose only a single option. On the other hand, the Paste Special feature in Excel 2011 for Mac lets you pick and choose exactly what individual or combination of attributes you want to paste.
- Select the cell or cell range to copy and choose Edit→Copy.
- Click in the cell where you want to paste and then choose Edit→Paste Special.
- In the Paste section of the dialog, select the option that you need.
- Click OK.
The Paste Link button becomes active depending on what you copied and which paste option you chose in the Paste Special dialog. The Paste Link button pastes a cell formula that refers to the cell you’re copying.
Turning rows into columns with Paste Special in Excel 2011 for Mac
Many times, you may wish you could easily change the layout of data from horizontal to vertical, or vice versa. Fortunately, Excel’s Paste Special Transpose option does exactly that.
![Excel Excel](/uploads/1/2/6/2/126226810/680248834.png)
To change columns into rows quickly, follow these steps:
- Select a cell range and choose Edit→Copy.
- Select a destination cell.
- Choose Edit→Paste Special.
- Select the Transpose check box and then click OK.
Using Paste Special with objects in Excel 2011 for Mac
If you copy an object, rather than a cell or cell range, the Paste Special dialog offers paste options appropriate to the kind of object you are pasting. Charts, tables, and pictures all have unique Paste Special options, each described within the description portion of the Paste Special dialog.
You can use the Paste Special feature in Excel by using content that you copied from another open application, such as Word, PowerPoint, or even a Web browser. Options in the Paste Special dialog change depending on what you’ve copied to the Clipboard.
Copying as a picture in the first place
You can easily copy a picture of an object, a cell, or a cell range, but you have to know about the secret Edit menu. Follow these steps to use the modified Edit menu:
- Select a cell, a range of cells, or an object on a worksheet.
- Hold down the Shift key and click the Edit menu.Here’s the secret! When you hold down the Shift key, the Edit menu offers Copy Picture and Paste Picture options.
- Choose Edit→Copy Picture.
- Click one of the choices:
- As Shown on Screen: What you see is what you get.
- As Shown When Printed: The picture is formatted based on your current selections in Page Setup.
Now, you have a picture on the Clipboard that you can use in Excel or any other application that can paste pictures.You can also hold Shift and choose Edit→Paste Picture to paste the Clipboard contents as a picture, regardless of its origin.
Excel 2016 makes it easy to insert online graphic images into your worksheet. The Insert Pictures dialog box enables you to use Microsoft’s Bing search engine to search the entire web for images to use. If that’s not enough, you can also download images that you’ve saved in the cloud on your Windows OneDrive or your social media sites, such as Facebook or Flickr.
To download an image into your worksheet from any of these sources, you click the Online Pictures button in the Illustrations group on the Insert tab of the Ribbon (Alt+NF). Excel opens the Insert Pictures dialog box similar to the one shown, containing the following options:
- Bing Image Search text box to use the Bing search engine to locate images on the web of a particular type that you want to add to your worksheet
- OneDrive Browse button to locate images saved on your SkyDrive to add to your worksheetSearching Office.com for clip art images of Tablet PCs in the Insert Pictures dialog box.
If you use a social media site such as Facebook or the photo-sharing site Flickr on your Windows device, you can add these locations as options to your Insert Pictures dialog box. Simply select the app’s icon that appears at the bottom of the Insert Pictures dialog box to connect Office with the particular app. You can then insert images from one of these sites after selecting its option in the Insert Pictures dialog box.
Inserting online images with Bing Image Search
To download an image with Bing, open the Insert Pictures dialog box (Alt+NF), then click in the Search Bing text box where you type the keyword for the types of images you want to locate. After you press Enter or click the Search button (the magnifying glass icon), the Insert Pictures dialog box displays a scrollable list of thumbnails for images matching your keyword, as shown here.
Selecting an image located with Bing Image Search to download into the current worksheet.
![Excel For Mac Paste Image Into Comment Excel For Mac Paste Image Into Comment](http://blog.mclaughlinsoftware.com/wp-content/uploads/2009/01/insertmaccomment5.png)
Below the initial row of thumbnails, the Insert Pictures dialog box also displays a disclaimer informing you that the online images that Bing has returned in the search use what’s called Creative Commons licensing that grants free distribution of what is otherwise copyrighted material under certain conditions (often noncommercial or educational use).
The disclaimer then goes on to urge you to review the license for any image you insert into your worksheet so that you may be certain that you are in compliance with these conditions (always a good idea). After reading this disclaimer, you can close its text box by clicking its Close button with the x in it.
You can then click a thumbnail in the list to display a short description plus the size (in pixels) of the image in the lower-left corner of the Insert Pictures dialog box as well as a hyperlink to the source web site (which you can use to visit this site to review the free use conditions of its Creative Commons license).
To get a better view of a particular image whose thumbnail is highlighted or selected in the list, click the View Larger button that appears in the thumbnail’s lower-right corner (the magnifying glass with a plus sign in it). Excel then displays a slightly larger version of the thumbnail in the center of the dialog box while at the same time blurring out all the other thumbnails in the background.
To insert one of the located images into the current worksheet, double-click its thumbnail if it’s not already selected in the list. If the thumbnail is selected, you can insert the image by clicking the Insert button or by pressing Enter.