How To Fix A Line In Excel

After inserting a picture in a prison cell, we oft face up some problems in Excel. Like while inserting a cavalcade or row, the picture is not moving with the cell automatically or while filtering, the picture is non filtered properly. In this tutorial, we'll try to show all the possible bug and constructive solutions with clear illustrations to gear up image in Excel cell.

Download Practice Workbook

You can download the complimentary Excel workbook from hither and practice on your own.

ii Solutions: How to Fix Image in Excel Cell

To explore the issues and solutions, nosotros'll utilise the following dataset that represents three popular companies' logos.

1. Image Is Not Moving and Sizing with Cells

The nearly common trouble we face while inserting an prototype is it is non moving with the jail cell when we insert a column or alter the size of a prison cell or filter them. Then then your worksheet will look weird. Merely no worries, there two like shooting fish in a barrel ways to ready it.

Accept a await, I inserted a cavalcade earlier Column C and the logos are remaining verbal in their positions.

Then run into, what happened when I filtered the dataset for merely Sony's logo-

It'southward not filtering the logos and the logos are non moving.

Solution 1: Mark Move and Size with Cells Option

In the Format Picture section in Excel, in that location is an option named Move and Size with Cells. If we mark it to apply for a moving picture then we can get rid of our problem.

Steps:

Select the logos and right-click your mouse.
Subsequently, select Format Object from the context bill of fare.

Shortly later, you will become the Format Picture filed on the right side of your sheet.

Click on the Backdrop icon then mark Motility and size with cells.

At present see, I added a column and the images moved with the cells.

And the filtering is working properly now.

Read More: Insert Pictures in Excel Automatically Size to Fit Cells

Solution two: Insert Image into Shape

The second best solution to the trouble is to insert a picture show into a shape rather than using the Motion-picture show command. It's quite easy, commencement, we'll insert a shape in a cell and then will insert an image as a shape fill.

Steps:

From the Insert ribbon, click on Shapes.
After that, select a rectangular shape from the appeared listing.

Next, drag your mouse afterward clicking on a prison cell to ready the shape. I dragged along Cell C5.
Afterwards, click as follows: Shape Format > Shape Fill > Motion picture.

A dialog box will open up before long to select the epitome from a source. My epitome is on my computer and so, I clicked From a File.

Finally, just select the image from the folder and press Insert.

See, the shape is filled with the image automatically, no need to darg here.

Post-obit the same procedure, insert other pictures.

Now if I insert a column the images volition motion with the cells.

Besides, the Filter command is working fine, with no trouble.

Read More: How to Insert an Image into a Cell with Excel VBA (2 Methods)

Similar Readings

How to Insert Picture from URL Using VBA in Excel (2 Methods)
How to Insert Picture in Excel Cell Automatically
Insert Moving picture in Excel Cell with Text (2 Easy Methods)
How to Insert Image in Excel Cell as Attachment (iv Examples)
How to Insert Picture in Excel Using Formula (two Examples)

two. Epitome Is Moving from a Protected Canvass

Some other mutual problem is- the image is moving from a protected canvas, but we know that no information or object can't move from a protected canvass. Take a look at the image below, I protected my sheet then dragged the logo of Sony and it's moving.

Solution: Marking Right Action Before Protecting Sheets

The reason is that you didn't mark the right action while protecting a canvas with a password. When you are gonna protect a sheet with a password and so it will allow yous to choose some commands those will work after protecting the sheet. If yous mark Edit objects and so whatever user will allow editing the prototype.

Unmark the Edit objects option while protecting your sail using the Protect command from the Review ribbon.

So any picture won't motility from the jail cell and can't exist edited.

Read More: Excel VBA: UserForm Prototype from Worksheet (3 Cases)

Decision

That'southward all for the article. I hope the procedures described to a higher place will be good enough to prepare an epitome in the Excel cell. Feel free to ask any question in the comment section and please requite me feedback. Visit ExcelDemy to explore more.

Related Manufactures

How to Insert Picture into Excel Jail cell (3 Methods)
How to Insert a Picture in Excel Header
Excel VBA: Insert Picture show from Folder (3 Methods)
How to Insert Moving-picture show in Excel Prison cell Background (three Methods)
How to Lock Prototype in Excel Cell (2 Methods)