adding picture cell

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Adding a picture to a cell

Adding a picture to a cell

resolvedResolved · High Priority · Version 2007

Joanna has attended:
Excel Intermediate course

Adding a picture to a cell

I would like to attach a picture to a single cell so that when I hover over the cell the picture will appear.

At the moment I am left with a huge picture taking over my sheet! Help

RE: Adding a picture to a cell

Hi Joanna

Thanks for getting in touch. This can be done via cell comments.

Right-click any cell and you will get the option to Insert Comment. Usually this is used for a text annotation. Once one has been inserted, click the border of the comment until it turns into dots (you'll know what I mean when you see it). Right-click the border and choose Format Comment.

On this new dialogue box, go to Colors and Lines and drop-down Fill Color. Choose Fill Effects and Picture. From here you should be able to browse for a picture to use as the pop-up.

I hope this helps.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Thu 8 Aug 2013: Automatically marked as resolved.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

New to Excel 2010 - Sparklines!

Excel 2010 includes a new feature called Sparklines which are tiny charts that fit into a single cell and plot data in cells from the worksheet. There are a host of formatting and styles that can be applied to them and they are really quite interesting.

>insert
>sparklines
>Choose any style you want

You will be asked for the range and it will automatically select the cell your in to insert the sparklines.

View all Excel hints and tips


Server loaded in 0.07 secs.