|
|
|
Put pictures in a comment box
Q Please tell me how I can put a picture into an Excel
comment box. Can it be done? Is there any help from Microsoft as to what to do?
Maureen White
A First, using suitable image-editing software, such as Microsoft Photo Editor or the free Irfanview, reduce your picture to a size of about 150 x 200 pixels.
Then start Excel in the usual way. Right-click on the cell where you want the picture and choose Insert Comment. Remove your name if it appears in the box. Point to the outer edge of the box and a cross made up of four arrows will appear.
Right-click and choose Format Comment and then the Colours and Lines tab. Under Line, Colour, choose No Line. Click down the Fill Colour arrow and choose Fill Effects and then the Picture tab. Click the Select Picture button and choose your picture. OK out.
You may have to pull down the bottom of the picture to compensate for any distortion, or pull out the side.
Under the View tab of Options on the Tools menu choose Comment indicator only. Then the picture will only appear when you point to the cell.
Related articles
Learn how to add and manage information effectively using Microsoft Word tables
Find out how to customise ready-made designs to create professional documents quickly
Try our secret Office tricks to get more from the document, spreadsheet and presentation tools and programs you use most often
Content Recommendation
Q.Why is Windows Backup skipping files?
Q.Why do my scanned documents display gibberish?
Q.How can I convert MTS files to edit in Windows Movie...
Updating your subscription status 
Grahics Interchange Format. A type of image file often used on the web, but now largely superseded by...
Save money by switching to fast 3G broadband
How to insert clip art in excel
All you have to do is click on the gray area and go and click on Formating Tool bar.
Posted by Austin, 11 Nov 2009
thank you bro
i've been trying to insert a picture for about an hour till i found this out really apreciate it
Posted by ivan, 10 May 2012