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.
- 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.
- 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.
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.
- 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.
- Now, if you insert or delete a column or row, you will notice that the text box remains at its initial spot.
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.