Adding jpegs to Excel
Thread Starter
Joined: Aug 2007
Posts: 3,133
Likes: 53
From: 4DME
Adding jpegs to Excel
Is it possible to add a jpeg to a cell on Excel? Have managed to add an external photo to a cell via a link but need an image in a cell if its possible.
During aircraft tare downs the part is recorded on excel but at present we have a separate data base for photos which need all the details typing in to identify the part.
Anyone got any simple instructions.
During aircraft tare downs the part is recorded on excel but at present we have a separate data base for photos which need all the details typing in to identify the part.
Anyone got any simple instructions.
Joined: Dec 2013
Posts: 1
Likes: 0
From: Norfolk
This is the sort of job that should be performed using an Access database. Excel is not the right tool for the job!
I can understand why you might be tempted to use Excel but it really is an abuse of a spreadsheet program which will lead to problems in the future. With anything more than a very few images the file sizes will become enormous very quickly indeed. Then you will have issues over the time it takes to retrieve records and load and save updates.
Use a database such as Access. This will also allow for screen layouts to be designed to replicate a spreadsheet with an option to select an image by clicking on a button, or to display a small thumbnail with the record. Exactly what you seem to want.
I can understand why you might be tempted to use Excel but it really is an abuse of a spreadsheet program which will lead to problems in the future. With anything more than a very few images the file sizes will become enormous very quickly indeed. Then you will have issues over the time it takes to retrieve records and load and save updates.
Use a database such as Access. This will also allow for screen layouts to be designed to replicate a spreadsheet with an option to select an image by clicking on a button, or to display a small thumbnail with the record. Exactly what you seem to want.
Joined: Apr 2008
Aviation Qualifications: SLF
Posts: 1,117
Likes: 228
From: troposphere
I routinely use Excel spreadsheets to do one -page 'site surveys' with text and up to 8 or 9 pictures. The trick is to compress the picture file size which can be done within Excel.
Never had a problem.
Never had a problem.
Joined: Dec 2002
Posts: 196
Likes: 0
From: 26000 to 28,000 lightyears from the galatic centre
Use hyperlinks
Using excel 2007 onwards , i currently use 2013
In your spreadsheet select the cell to use as a hyperlink
From the main menu line
FILE HOME INSERT Page layout etc
select Insert
Within the Insert options look over to the right and you will see Hyperlink
Selrct the cell yout want to display the .jpeg
then select Hyperlink
look through all the optioms find pictures, select the one you want, then that cell links to that .jpeg or any other file etc.
Sorry about spellinging , got bat jet lag and aussi flu with achest infection.
Hope this helps
***
In your spreadsheet select the cell to use as a hyperlink
From the main menu line
FILE HOME INSERT Page layout etc
select Insert
Within the Insert options look over to the right and you will see Hyperlink
Selrct the cell yout want to display the .jpeg
then select Hyperlink
look through all the optioms find pictures, select the one you want, then that cell links to that .jpeg or any other file etc.
Sorry about spellinging , got bat jet lag and aussi flu with achest infection.
Hope this helps
***
