You can easily insert pictures into your document, whether they are on your computer or on the Web. Click where you want to insert the picture in your document.
Insert a picture that is stored on your computer. On the Insert tab, in the Illustrations group, click Picture. Locate the picture that you want to insert.
Paste Special options. Select the cells that contain the data or other attributes that you want to copy. On the Home tab, click Copy. Click the first cell in the area where you want to paste what you copied. On the Home tab, click the arrow next to Paste, and then select Paste Special. Select the options you want. There is no 'Comment Format > Colors and Lines > Color Drop-down > Fill Effects > Picture' option on my end (which is the solution I found for Office 2011 Mac). The 'comment format' for me is limited to 'Font, Protection, Alignment, Properties' none of which has the solution, at least to my knowledge.
For example, you might have a picture file located in Documents. Double-click the picture that you want to insert. Insert clip art. On the Insert tab, in the Illustrations group, click Clip Art. In the Clip Art task pane, in the Search for text box, type a word or phrase that describes the clip art that you want, or type in all or some of the file name of the clip art. Click Go, and then in the list of results, click the clip art to insert it into your document.
When you search for clip art and pictures online, you'll be directed to Bing. You're responsible for respecting, and the can help you choose which images to use. Next steps To resize a picture, select the picture you've inserted in the document. To increase or decrease the size in one or more directions, drag a sizing handle away from or toward the center. To learn more about adding pictures, drawings, and other graphical elements to your documents, see the following articles:.
Tip Office.com is continuously updated with new content, including how-to articles, videos, and training courses. If the bottom of the Help Viewer says Offline and you are connected to the Internet, click Offline, and then click Show content from Office.com.
Threaded Comments Microsoft is introducing Threaded Comments in Office 365, so you might see those soon, if you don't have them already. WARNING Before you use Threaded Comments, instead of old-style (Legacy) comments, be sure to understand what features you will lose. Legacy comment features, such as, inserting or adding colors, will not be available in Threaded comments. Thanks to Bill Jelen (Mr. Excel) for this warning - 'If you try to edit an old comment, a long message will tell you to Convert to Threaded Comments and all of your comment formatting will be lost.'
Legacy Comment Icons The old-style (Legacy) comments will still be available, but the icons to create and edit them will be hidden. To continue working with Legacy comments, add the following icons to, or to the Excel Ribbon:. New/Edit Comment (Legacy). Previous Comment (Legacy). Next Comment (Legacy).
Show/Hide Comments (Legacy). Show All Comments (Legacy) Threaded Comments Video To learn more about Excel Threaded Comments, watch this video by Bill Jelen. Your browser can't show this frame.
Here is a link to the page Change the User Name Instead of showing the user name at the start of an Excel comment, you can change to something generic, such as 'Note:' However, this change affects the User Name in all Microsoft Office programs, so you may want to reset the name before you exit Excel. To change your User name:. At the top left of the Excel window, click the File tab. Click Options, and in the Options window, click the General category. Scroll down to the section, 'Personalize your copy of Microsoft Office'. Delete the existing User Name, and type a new entry. Click OK Copy Comment to Other Cells If you want the same comment in multiple cells, you can copy and paste an existing comment.
Select the cell with the comment that you want to copy. Press Ctrl + C, to copy the cell. Select the cell(s) where you want to paste a copy of the comment. On the Ribbon's Home tab, click the Paste button, and then click Paste Special. In the Paste Special window, under Paste, click Comments. Click OK Change the Comment Shape Add a bit of interest to a worksheet, by changing the comment shape from a rectangle. NOTE: Shapes are not available with.
Watch the video, to see the steps for in Excel 2007 or later. Written instructions are below the video. Click here to go to the. Your browser can't show this frame. Here is a link to the page Change a Comment Shape First, add the Change Shape command to the QAT. At the right end of the QAT, click the drop down arrow. Click More Commands.
In the Choose Commands From drop down, click All Commands. In the list of commands, click Change Shape, and click Add, to move it to the Quick Access Toolbar. Close the Excel Options window. Next, follow these steps to change the comment shape. Right-click the cell which contains the comment. Choose Edit Comment.
Click on the border of the comment, to select it. On the QAT, click the Change Shape command, and click on a shape to select it.
When finished, click outside the comment. To change the comment shape in Excel 2003:. Right-click the cell which contains the comment. Choose Edit Comment.
Click on the border of the comment, to select it. On the Drawing toolbar, click the Draw button. Choose Change AutoShape, and choose a category. Click on a shape to select it. When finished, click outside the comment. Add Picture to Comment To see how to add a picture to a comment, watch the steps in this short video.
The written instructions are below the video. NOTE: Pictures are not available with. Your browser can't show this frame. Here is a link to the page Add Picture to Comment NOTE: These instructions are for Excel 2007 and later versions. See below for. Instead of text, you can show a picture in an Excel comment. Right-click the cell which contains the comment.
Choose Show/Hide Comments, and clear any text from the comment. Click on the border of the comment, to select it. Choose Format Comment. On the Colors and Lines tab, click the drop-down arrow for Color. Click Fill Effects.
On the picture tab, click Select Picture. Locate and select the picture. To keep the picture in proportion, add a check mark to Lock Picture Aspect Ratio. Click Insert, click OK, click OK Add Picture to Excel 2003 Comment Instead of text, you can show a picture in an Excel comment. Watch the steps in this short video, and the written instructions are below.
Your browser can't show this frame. Here is a link to the page To add a picture to a comment in Excel 2003:. Right-click the cell which contains the comment. Choose Show/Hide Comments, and clear any text from the comment.
Click on the border of the comment, to select it. Choose Format Comment. On the Colors and Lines tab, click the drop-down arrow for Color. Click Fill Effects.
On the picture tab, click Select Picture. Locate and select the picture. To keep the picture in proportion, add a check mark to Lock Picture Aspect Ratio.
Click Insert, click OK, click OK Change the Default Font Size You can change the font size of new Excel comments by changing the settings in your Control Panel. (Instructions for Windows XP).
Right-click on the desktop, and choose Properties. On the Appearance tab, click Advanced. From the Item dropdown, choose Tooltip. Choose a font Size, click OK, click OK ( Note: selecting a font type here will not affect the default font used in Excel comments) Change the Comment Indicator Colour Comment indicators are red, and there's no option to change that setting. As a workaround, you can draw triangular shapes over the indicators, and fill them with a different colour from the palette. For instructions, see Alternative to Excel Comments Add a comment to a Data Validation Input Message, and it can be displayed when you tab to the cell. Select the cell in which you want to see the message.
On the Ribbon's Data tab, click Data Validation. Click on the Input Message tab to activate it. Add a check mark to 'Show input message when cell is selected'. Type your message heading text in the Title box. This text will appear in bold print at the top of the message. Type your message in the Input message box.
Click OK Download Sample File To see comment shapes and pictures,. The zipped file is in xlsx format, and does not contain any macros. More Tutorials.