Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Creat a database in Excel with pictures


18 Mar 2014   #1

Windows 7 Professional 32 bits
 
 
Creat a database in Excel with pictures

I need to create a small database in Excell that will have info about company employees and their pictures. How do I put seperate pictures into cells?

My System SpecsSystem Spec
.

18 Mar 2014   #2

Windows 7 Home Premium 64 bit sp1
 
 

What version of Excel are you using. I am using Excel 2013 which is part of Office 2013 Pro. If you are using Excel 2013 you can insert pictures by selecting the Insert tab on the menu Ribbon & selecting Pictures & follow the directions from there.
Other versions of Excel have a similar function for inserting pictures. Experiment with a blank worksheet first until you get the system to work for you.
My System SpecsSystem Spec
18 Mar 2014   #3

Linux Mint 17 Cinnamon | Win 7 Ult x64
 
 

By default, inserting images in Excel does not anchor them to a cell. They float.

If that is all you need, then simply follow Ranger4's advice. If however, you want the image tied to a specific cell, read on..

There are two ways to add images to a cell in excel.

1. Insert image in a comment box. When you mouse over the cell the picture will show.
2. Anchor the image to the cell using a hyperlink.

For the first way...
  • Right-click on the cell and insert a comment.
  • Right click on the border of the comment.
  • Select Format Comment
  • Select the colors and lines tab
  • On the color dropdown select fill effect
  • Select the Picture tab
  • Navigate to your picture and click Ok.
For the second way...
  • Assuming you have the picture inserted already..
  • You have to name the cell first (Right click, define name).
  • Right click the picture
  • Click on Hyper link
  • Select place in this document
  • Locate the name you just defined and select it
  • Click Ok.
  • The picture is now anchored to that cell.

You may need to adjust the cell or image dimensions to match the cell/image size
My System SpecsSystem Spec
.


18 Mar 2014   #4

Windows 7 Professional 32 bits
 
 

Ranger4, inserting an image would be easy but having it conform to a cell and move with the rest of the data is harder.

What about linking to the image file? Can Excell link to files?

I have Office version 2007, I'm so far behind because most companies in this country either work with Office 200 or 2007
My System SpecsSystem Spec
19 Mar 2014   #5

Windows 7 Home Premium 64 bit sp1
 
 

Have you tried TantaC's suggestions.

Also you could refer to this MS website & under "Insert Pictures from a File" there are methods of linking a picture in Excel 2007.

Insert a picture or clip art - Excel - Office.com
My System SpecsSystem Spec
24 Mar 2014   #6

Windows 7 Professional 32 bits
 
 

Sorry for the late answer. TanyaC, thank you for the detailed answer with the required steps. I thought I could hyperlink to an image outside the document as well
My System SpecsSystem Spec
Reply

 Creat a database in Excel with pictures




Thread Tools



Similar help and support threads for2: Creat a database in Excel with pictures
Thread Forum
Unable to open Excel File over a shared database in BCM - Office 2010 Microsoft Office
How to creat one shortcut to launch multiple programs? and more. Customization
help me in the confusion to creat system image Installation & Setup
Setup was unable to creat a new system partition Installation & Setup
BSOD when opening pictures or saving in word/excel BSOD Help and Support

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 07:06 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33