excel+courses - images
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel+courses - Images

excel+courses - Images

resolvedResolved · Low Priority · Version Standard

replyReply Wed 19 Dec 2007, 09:54Delegate Stuart said...

Stuart has attended:
Access Consulting course

Images

Hi,

I'm mostly ok inserting pictures into Excel sheets but I'm wondering if there is a way to embed them into the cell so I can perform a V-Lookup or simmillar calculation to pull it through to another worksheet?

For example, I work for a shoe company and we have a catalogue of Shoes. I produce various line reports for the company and would like to be able to easily link a cell in my reports to show an image of the line - say in a list of the weeks bestsellers etc?

Apologies if this question has already been answered, I couldn't see anything in the first few pages!

Many Thanks,

Stuart

For upcoming training course dates see: Pricing & availability

replyReply Wed 19 Dec 2007, 11:40Delegate Paul said...

RE: Images

I don't think it's possible without some hefty code

replyReply Thu 24 Jan 2008, 15:12Trainer Rich said...

RE: Images

A database would be better suited for this type of application.

Regards, Rich

 

Excel tip:

Switch on smart tags – Excel 2007

In order to use smart tags, make sure they are turned on, to do this:
1. Click on ‘Microsoft Office‘ button and then click on ‘Excel Options‘.
2. Click on ‘Proofing‘ category and then click on ‘Auto Correct Options‘.
3. In the ‘Auto Correct‘ dialogue box appears, click the ‘Smart Tags‘ Tab.
4. Tick the boxes, next to the Smart Tags you wish to use in Excel

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard