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?
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.
Updating your subscription status