Simple clear advice in plain English

Add a picture to an Excel cell

How to copy a picture from a file and add it to a cell in Excel

Q When using Windows XP, I was able to copy a picture from a file and add it to a comment relating to a particular cell on an Excel spreadsheet.

I'm now using Windows Vista Basic and would like to be able to do the same. Is this still possible using Vista Basic, and second, if it is possible would you remind me of the procedure?
Dave May

A The version of Windows is irrelevant ­ it’s the version of Excel that matters.

The most recent versions allow you to do it.

Right-click on a cell and choose insert Comment. Highlight your name, if it appears, and press Delete.

Hover on the edge of the Comment box until a double-headed arrow appears.

Right-click and choose Format Comment. Click the Colors and Lines Tab.

Click the down arrow near the Fill Color: box.

Choose Fill Effects and then the Picture tab. Click the Select Picture button, which takes you to your My Pictures folder.

From there, navigate to the picture of your choice and select it and click Insert and OK twice.

Chances are the picture will be distorted so correct this by dragging out the sides of the Comment box.

Article tags

Reader Comments

   

Add your comment

All fields must be completed. Your email address will not be displayed or used to send marketing messages.

All messages will be checked by moderators before appearing on the site.

See our Privacy Policy for more information.

Related articles

Make email newsletters with Word illustration

Use Word 2003 or 2007 to create attractive email newsletters

Word can help you make an email newsletter containing photos and clickable links. We show you how to make the most of Microsoft's templates

Using Wizard to create a form

Create a good Base for your data

Databases may sound very dreary but they are behind almost everything we do. We explain how to go about starting one of your own using Libre Office Base

Word's undo feature

How to fix common PC errors

It’s easy to hit the wrong key when using a PC and throw yourself into a panic. There's no need to worry - we have easy fixes for 30 common everyday errors

Question & Answer

Q.How do I store musician and other information about...

> Read the answer

Q.Why can't my browser find the website address I typed...

> Read the answer

Q.All updates have been downloaded, so why won't Windows...

> Read the answer

Best deals on the web

img

THREE E585 Mi-Fi Take it Away Mobile Broadband - 5GB allowance

£44.97- Buy it now

img

T-MOBILE 3G Pay As You Go iPad Micro SIM

£0.10- Buy it now

img

THREE Huawei E353u Take It Away Mobile Broadband - One Month Rolling Contract

£4.99- Buy it now

Great benefits for subscribers!

Poll

Which is your preferred web browser

Jargon Buster

Computing terms explained in plain English

CAD

Computer Aided Design. Software used to create 3D models.

Great shopping deals from Computeractive