You can then edit the comment by adding text, formatting that text or many other formatting options that are available. I'm going to remove the text, and resize it to be a square:Ģ) move my cursor to the very edge so it turns into a four arrow-head cursorĩ) select my picture from wherever I have it stored While in this status, I can move it, resize it, delete the text, etc. …or I can go to the Review tab and select New Note under the Notes Option:Ī new note will appear with the author's name (or however you may have the settings): Then I can either right click and choose "New Note":
You actually don't need to type in any text) in a cell in Excel. Additionally, it also automates the task of associating a photo with a file name from a cell and exports all images to a folder with that file name. Here you can see that when I hover over cell H3 with the text "Pittsburgh Penguins" (I'm a Penguins hockey fan!), an image of their logo pops up:įirst, I'll type "Pittsburgh Penguins" (or whatever text you want. There is a way today, with an add-in called Picture Manager for Excel that effortlessly imports any desired number of images automatically sized to fit cell. So in this tutorial I want to show you the subtle difference as to how you can now insert a Photo into the new Notes option. However, in Office 365, Excel changed Comments to be an interactive thread/conversation, and the old style Comments are now called Notes. In the previous tutorial mentioned above, at about the 4:20 mark, I showed how to insert a photo in a Comment in Excel. The previous tutorial on this topic can be found here. When you get a preview, look for Download in the upper right hand corner.
You can download the file here and follow along. In this tutorial we are going to see how to insert a picture or photo in a comment (now called Notes) in Excel in Office 365.
0 kommentar(er)
