Move and Size with Cells in Excel (3 Examples)

Excel treats an inserted object floating over the worksheet. Sometimes it is okay for demonstrations. But in some cases, you may need to associate one with a cell i.e. your object needs to move or resize when the cell is moved or resized. Excel has a property to do so. In this article, I am going to show you how to move and size objects with Cells in Excel with examples.


Download Practice Workbook

You can download the workbook used for this demonstration with different datasheets included in different spreadsheets below. Download and try yourself while you go through the steps.


3 Examples to Move and Size with Cells in Excel

To move and size objects with cells, in Excel there is a property called Move and size with cells. Checking this option is the primary method to achieve such a result. Here, in this tutorial, I will show you to use this method in different scenarios- for pictures, checkboxes, and shapes. Follow along to see each case, or find the one you need from the table of contents above.


1. Move and Size Pictures with Cells in Excel

Let’s take a dataset with pictures included in cells. I have taken the following dataset with soccer players with their photos in them.

move and size with cells in excel

First of all, if you need to know how to insert images into cells go to the Insert tab. Click on Pictures and select the source and picture you want to add.

But added pictures may not move or size when the cell is moved or resized.

move and size with cells in excel

To enable the feature where the pictures move if the cell is moved or be smaller or larger when the cell dimensions are changed, follow these steps.

Steps:

  • First, select all the images which you want to situate with the cell.

  • Then right-click on one and in the context menu select Format Objects. Doing so, a Format Picture window will pop up.

  • In the Format Picture window, go to the Size & Properties tab and select Properties in it.
  • Under the Properties options, check the Move and size with cells option.

move and size with cells in excel

  • After that, close the window and you will have your objects move and size with cells in an Excel spreadsheet.

Now you can try moving a particular cell, the image will move with it. I am moving cell C6 by clicking and dragging.

move and size with cells in excel

Read More: Excel Formula to Move Data from One Cell to Another


Similar Readings


2. Move and Size Checkboxes with Cells in Excel

You can associate checkboxes with cells too to move and size with cells in Excel. For demonstration, I am using the dataset below.

move and size with cells in excel

If you don’t know how to add a checkbox, go to the Developer tab on your ribbon. Then go to Controls > Insert and select the checkbox under ActiveX Controls.

But the checkboxes may not move or size with the cell after you have moved or resized the cell.

It contains whether the soccer players had won the Ballon D’or trophy or not. I have used checkboxes to indicate such results. To learn how checkboxes move and size with cells in Excel follow these steps.

Steps:

  • First, make sure the checkboxes are in Design Mode.

  • Then select all the checkboxes you want to associate with particular cells.

move and size with cells in excel

  • Now right-click on one and select Format Object from the context menu.

  • A Format Control box will appear. In it, go to the Properties tab, and under Object positioning, select the Move and size with cells option.

how to move and size with cells in excel

  • Finally, click on OK.

The checkboxes will now move and size with cells when it is moved or reshaped.

how to move and size with cells in excel

Read More: How to Shift Cells Up in Excel (5 Quick Ways)


3. Move and Size Shapes with Cells in Excel

You can also move and size shapes with cells. Let’s take a dataset containing different shapes like the one below.

how to move and size with cells in excel

If you don’t know how to add arrows/shapes, then from your ribbon go to the Insert tab. Then click on Shapes and select the shape you want to insert.

But shapes inserted this way may not move or size when the cell is moved or resized.

how to move and size with cells in excel

To associate these shapes with the cells so that you can move and size with cells in Excel, you need to follow these steps.

Steps:

  • First, select the shapes you want to move and size with cells. I have selected the one in cell C5 for demonstration.

  • Then right-click on the shape and select Format Shape from the context menu.

how to move and size with cells in excel

  • In the Format Shape window, go to the Size & Properties tab.
  • Under Properties, check the Move and size with cells option.

how to move and size with cells in excel

  • After that close the window.

You are done formatting the shape to move and size with cells in Excel. You can repeat the process for as many shapes as you want. Now the shapes with the move and resize if you move the cell or resize it.

how to move and size with cells in excel

Read More: How to Move Cells without Replacing in Excel (3 Methods)


Similar Reading


Move and Size with Cells Not Working in Excel

There is a common problem you can run into while formatting checkboxes to move and size in Excel- you may find the Move and size with cells option in the Format Control box greyed out.

how to move and size with cells in excel

This may usually occur when you insert Check Box(Form Control) instead of Check Box (ActiveX Control) while you insert it from the Developer tab. To insert the correct type of checkbox so that you can format it to move and size with cells, you need to select it from the selected option in the picture (under the ActiveX Controls).

If you select checkboxes from here, you can have the format option to move and size with cells.

Read More: [Fixed!] Unable to Move Cells in Excel (5 Solutions)


Conclusion

These were the different scenarios where you can format content to move and size with cells in Excel, including a common possible error. Hope you have found this article helpful and informative. If you have any questions or suggestions, let us know down below. For more in-depth guides like this, explore Exceldemy.com.


Related Articles

Abrar Niloy

Abrar Niloy

Hi! my name is Abrar-ur-Rahman Niloy. I have completed B.Sc. in Naval Architecture and Marine Engineering. I have found my calling, if you like, in Data Science and Machine Learning and in pursuing so, I have realized the importance of Data Analysis. And Excel is one excel-lent tool do so. I am always trying to learn everyday, and trying to share here what I am learning.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo