Menu
Text boxes in Excel 2013 and 2010 provide a way to add large blocks of text atop a spreadsheet. When you write in a text box, the text can contain multiple styles, fonts, colors and line breaks, just as if you were typing in a Word document. Editing text in text boxes--please help--driving me crazy! I need to edit the text in those boxes, and I can't figure out how to access the text! I can't click inside the text box and edit it. In Office for Mac 2011, if you click on the text box frame then right click, select edit text to alter it. To alter its format, click on the.
- How To Delete A Text Box From A Word Document
- How Do You Delete A Text Box
- I Can't Delete A Text Box In Excel For Mac
- How To Delete A Text Box In Microsoft Word
Hi Bgg_005,
![How to delete a text box in google slides How to delete a text box in google slides](https://d2d42mpnbqmzj3.cloudfront.net/images/stories/doc-excel/delete-pictures/xdoc-delete-pictures1-1.png.pagespeed.ic.7sP28-Wk74.png)
Based on my test, the sheet row is different from table row (“Move but don’t size with cells” selected). When we insert a sheet row, text box will move. However, when inserting a table, the Text Box doesn’t move. As a workaround, you may directly move the Text box to a proper position. You may also firstly insert sheet rows which make text box move, and then create table.
Other community members are welcome to share your experience about this thread here.
Best regards,
Tim
Did this solve your problem?
Sorry this didn't help.
Great! Thanks for marking this as the answer.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this response?
Thanks for your feedback.
How To Delete A Text Box From A Word Document
@Tim thank you for your reply. Yes, it does seem as though table rows are different from sheet rows, for whatever reason. Content in cells below a table move with table insert/delete rows but content in cells beside a table do not. Since my worksheet is intended for distribution among co-workers, neither 'workaround' is entirely satisfactory. What is needed is a way to lock or anchor a text box to a particular cell or worksheet row, which does not seem to be possible.
Did this solve your problem?
Sorry this didn't help.
Great! Thanks for marking this as the answer.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this response?
Thanks for your feedback.
I just experimented with a table below a range of cells and below an Excel table. The text box moved up when I deleted rows from the range and it moved up when I deleted rows from the table. I have the text box set to move and size with cells.
![I Can I Can](/uploads/1/2/6/0/126081909/418012885.png)
Can you share an example workbook on DropBox or OneDrive or other sharing service and provide a step-by-step set of instructions that reproduce the problem you're having?
It would help if you go to the Excel menu and choose About Excel and include your version information.
Thanks.
I am an unpaid volunteer and do not work for Microsoft. 'Independent Advisors' work for contractors hired by Microsoft. 'Microsoft Agents' work for Microsoft Support.Did this solve your problem?
Sorry this didn't help.
Great! Thanks for marking this as the answer.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this response?
Thanks for your feedback.
How Do You Delete A Text Box
@Jim,
Thank you for your reply. Yes, text boxes and content in cells below a table move with table insert/delete rows. However, text boxes or content in cells beside a table do not.
What I was looking for was a way to lock or anchor a text box to a particular cell or worksheet row. Unfortunately, this does not seem to be possible. I have since moved on. Thanks everyone for your suggestions.
Did this solve your problem?
Sorry this didn't help.
Great! Thanks for marking this as the answer.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this response?
Thanks for your feedback.
This behavior has to do with the special way the Excel Table object behaves. When you add a row to a table other non-adjacent columns are not affected. If you add a complete row using the Insert menu Insert > Rows, then your text box will move down.
I am an unpaid volunteer and do not work for Microsoft. 'Independent Advisors' work for contractors hired by Microsoft. 'Microsoft Agents' work for Microsoft Support.Did this solve your problem?
Sorry this didn't help.
Great! Thanks for marking this as the answer.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
I Can't Delete A Text Box In Excel For Mac
How satisfied are you with this response?
How To Delete A Text Box In Microsoft Word
Thanks for your feedback.