Posted 05/06/2011 4:32 pm
you can certainly store photos in excel but it makes the file pretty big, really quick.
roughing out the instructions (and this might be different slightly depending on your version of excel):
Try doing this in the Comment section of a cell
1. Right-click the cell which contains the comment or you want to add comment..
2. Choose Show/Hide Comments, and clear any text from the comment. If adding the comment, choose insert comment and then continue.
3. Click on the border of the comment, to select it.
4. Choose Format|Comment
5. On the Colors and Lines tab, click the drop-down arrow for Color.
6. Click Fill Effects
7. On the picture tab, click Select Picture
8. Locate and select the picture, click insert
9. To keep the picture in proportion, add a check mark to Lock Picture Aspect Ratio
10. click OK, click OK
it is bulky but it does work. And if someone knows a better way, please let me know.
roughing out the instructions (and this might be different slightly depending on your version of excel):
Try doing this in the Comment section of a cell
1. Right-click the cell which contains the comment or you want to add comment..
2. Choose Show/Hide Comments, and clear any text from the comment. If adding the comment, choose insert comment and then continue.
3. Click on the border of the comment, to select it.
4. Choose Format|Comment
5. On the Colors and Lines tab, click the drop-down arrow for Color.
6. Click Fill Effects
7. On the picture tab, click Select Picture
8. Locate and select the picture, click insert
9. To keep the picture in proportion, add a check mark to Lock Picture Aspect Ratio
10. click OK, click OK
it is bulky but it does work. And if someone knows a better way, please let me know.
