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
mohab

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
Ranger4

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
TanyaC

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
mohab

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
Ranger4

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
mohab

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
Thread Forum
4gb ram with 2gb ram ... will it creat problem ??
My pc contains only 4gb ddr3 ram on 2+2 on two different slots & I want to upgrade it to 2+4=6GB . So there will be 2gb in one slot and 4 gb in another slot . Will there be any problem because of the two different memory (I will buy the same frequency & same manufacturer ram ) . So one slot will...
Hardware & Devices
Can I creat a mapstructure using meta-data of a file?
Is there an application that can create a map-structure of my e-books (epub, pfd, mobi) using meta-data? A structure like; Subject Auteur Title
Software
How to creat one shortcut to launch multiple programs? and more.
Ok, so i have a few questions. instead of making thread for each. i am posting them hear. 1. like the title says, i want to know how to create one shortcut to launch multiple programs( Two or three programs at once)? (edit: i have founded a tutorial on the forume. but it is a bit complicated)...
Customization
help me in the confusion to creat system image
he friends...pls make me clear as much as u can 1. when i create system image disc then is it necessary to backup in external drive?cant i back up in d or e drive while creating the system image of system and c drive? there are two check marks in system and c drive so i will not put check marks in...
Installation & Setup
Setup was unable to creat a new system partition
Clean install of windows 7 on 2 160gb sata HDD's set up for a raid 0 when i select a partition to install the OS onto it gives me the error "Setup was unable to create a new system partition or locate an existing system partition. see the Setup log files for more information." any...
Installation & Setup
BSOD when opening pictures or saving in word/excel
Hi there, I have been suffering from a repeating crash whenever I save word or excel files or open up pictures. It is the same error popping up over and over again, I ran the mem test 6 times, 5 regular and 1 extended everything checks out. BIOS on mobo has been updated from website, I have no idea...
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 01:03.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App