Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations JAE on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Doubt in inserting image to cell 2

Status
Not open for further replies.

raviprakash369

Aerospace
Joined
Mar 25, 2015
Messages
49
Location
IN
Hi all,
can anyone please help me how to fix an image to cell in the excel sheet.
cell should not move and image should be fixed to particular cell.

Thanks & regards,
Ravi.
 
As far as I know you can't fix a chart to a cell, but you can protect the sheet, so the chart can't be moved or re-sized. See here:


Also, (in Excel 2013/2016) when you click "Protect sheet" you get a dialog box. Scroll down to the bottom and make sure that "Edit objects" is not selected. If it is selected the chart can still be moved even when the sheet is protected.

Doug Jenkins
Interactive Design Services
 
1. The image must be totally inside a cell (i.e., the cell height & width is bigger than the image).
2. Protect the sheet so the cell cannot be resized.
 
Hi,

Select your image.

Format > Size > Properties...

...and select which one of the three OPTIONS you wish to assign to your image.

Skip,

[glasses]Just traded in my OLD subtlety...
for a NUance![tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top