Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 10-04-2012
Member
 
Join Date: Apr 2012
Posts: 2
idea automatically fit a picture on each cell of a column in MS-excel 2007

hello i have a problem creating an automation like automatically fitting a picture on each cell of a columns without any re-sizing the picture in windows excel 2007. Is anybody have ideas on it?
Reply With Quote
  #2  
Old 10-04-2012
Member
 
Join Date: Dec 2007
Posts: 1,728
Re: automatically fit a picture on each cell of a column in MS-excel 2007

At first the picture is entered on the spreadsheet make sure it fits in the cell that you want it to be in. The entire size of the picture has to fit into that cell. Once you have that done, right click on the picture, and select format picture. Under the properties tab, select move and size with cells. Click ok. Now it should stay in the row you want. You can also refer to some suggestions given in similar kind of threads here - How to insert pictures into Excel automatically ?
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "automatically fit a picture on each cell of a column in MS-excel 2007"
Thread Thread Starter Forum Replies Last Post
Not able to address vba in the first visible cell in a Column after filtering in Excel SirName MS Office Support 1 25-01-2012 06:27 PM
insert picture in excel 2007 based on cell reference joe.polkendare Windows Software 5 25-07-2011 11:40 PM
How to highlight identical cell value of one column in another column? D_chapple Windows Software 3 09-12-2009 01:11 PM
Excel 2007 change Maximum no of Column Sachit Windows Software 3 08-07-2009 10:10 AM
Auto hide rows and column in Excel 2007 Murena Windows Software 3 28-02-2009 07:00 PM


All times are GMT +5.5. The time now is 07:33 PM.