How to Anchor Text Box in Excel (2 Ideal Examples)

Get FREE Advanced Excel Exercises with Solutions!

In Microsoft Excel, we can insert multiple types of text boxes. But, those text boxes remain floated in the worksheet. As a result, it moves from one place to another when we insert or remove a row. In this article, we are going to demonstrate to you 2 ideal examples to anchor a text box in Excel. If you are also curious about it, download our practice workbook and follow us.


How to Anchor Text Box in Excel: 2 Ideal Examples

To demonstrate the examples, we consider a dataset of 5 employees of a store. We will trace their presence over the weekend. So, our dataset is in the range of cells B6:E10. Now, we will anchor the box of column D to demonstrate the procedure.

📚 Note:

All the operations of this article are accomplished by using the Microsoft Office 365 application.


1. Anchoring Text Box from Format Shape Option

In this example, we are going to anchor the text box from the Format Shape command. You will find this command while the text box inserted from the Insert tab. We will anchor the text box of column D.

The steps to accomplish this example are given below:

📌 Steps:

  • First, click on the text box in column D.
  • Now, right-click on your mouse to launch the Context Menu and choose the Format Shape option.

Opening Format Shape dialog box to anchor text box

  • As a result, a side window called Format Shape will appear.
  • After that, from the Shape Options section, click on the Size & Properties option.
  • Then, click on the drop-down arrow of the Properties option and check the Don’t move or size with cells option.

Choosing suitable option to anchor the text box

  • The text box will anchor in the cell.
  • Now, even if you insert or delete a column or row, the text box remains at its initial position.

Anchor Text Box from Format Shape Option

Thus, we can say that our approach works properly, and we are able to anchor the text box in Excel from the Format Shape menu.

Read More: How to Add a Dynamic Text Box in Excel


2. Using Format Control

In the following example, we will anchor the text box from the Format Control command, which is inserted from the Developer tab. We are going to anchor the text box of column D.

The steps to finish this example are given as follows:

📌 Steps:

  • First, in the Developer tab, click on the Design Mode option.

  • After that, right-click on the text box in column D and select the Format Control option from the Context Menu.

Launching Format Control dialog box to anchor text box

  • As a result, a small dialog box called Format Control will appear.
  • Then, in the Properties tab, select the Don’t move or size with cells option.
  • Finally, click OK.

Select the suitable option to anchor test box from Format Control

  • Now, if you insert or delete a column or row, you will notice that the text box remains at its initial spot.

Using Format Control dialog box to anchor a text box

Hence, we can say that our procedure works successfully, and we are able to anchor the text box in Excel from the Format Control option.


Download Practice Workbook

Download this practice workbook for practice while you are reading this article.


Conclusion

That’s the end of this article. I hope that this article will be helpful for you and that you will be able to anchor the text box in Excel. Please share any further queries or recommendations with us in the comments section below if you have any further questions or recommendations.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Soumik Dutta
Soumik Dutta

Hi! I am Soumik. I have completed my Bachelor of Science in Naval Architecture and Marine Engineering. I have found my calling in Machine Learning and Data Science, and in pursuing so, I have realized the importance of Data Analysis. Excel is one excellent tool to fulfill the purpose. I am always trying to learn every day about different features of Excel and trying to share here what I am learning.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo