Doubt in inserting image to cell
2

Question

Doubt in inserting image to cell

raviprakash369 (Aerospace)

(OP)

1 Mar 16 06:33

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.

IDS (Civil/Environmental) · Answer 1 · 2016-03-01 07:51:49

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:

http://smallbusiness.chron.com/lock-position-chart...

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
http://newtonexcelbach.wordpress.com/

zelgar (Civil/Environmental) · Answer 2 · 2016-03-01 13:48:50

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.

SkipVought (Aerospace) · Answer 3 · 2016-03-02 00:13:18

Hi,

Select your image.

Format > Size > Properties...

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

Skip,
_{Just traded in my OLD subtlety...

for a NUance!}

darkjmf1 (Structural) · Answer 4 · 2016-03-03 14:14:16

Maybe you could give this a try:
https://www.youtube.com/watch?v=TSjEMLBAYVc

Come Join Us!

Posting Guidelines

Doubt in inserting image to cell
2