Forum Discussion

prkammann's avatar
prkammann
Copper Contributor
Jan 31, 2020

Excel text box overlay- what is it, how to remove?

I have this box that has somehow been inserted into my table.  There are underlying cells and I can actually scroll right under this box and also access the cell underneath it.  And I can type about 140 characters into this box.  Deleting surrounding rows or columns does not affect the box, so it doesn't appear to be correlated to a specific cell.  There is no context sensitive help when in the box and almost all normal excel functions are greyed out when I'm in it. 

 Any help is appreciated.

excel

9 Replies

  • prkammann's avatar
    prkammann
    Copper Contributor
    Jan 31, 2020

    I had another pro figure it out, it is a text box inserted in Design function in the developer tab.  prkammann 

  • PReagan's avatar
    PReagan
    Bronze Contributor
    Jan 31, 2020

    Hello prkammann,

     

    If you do not have the Developer tab follow here:

    https://support.office.com/en-us/article/show-the-developer-tab-e1192344-5e56-4d45-931b-e5fd9bea2d45

     

    In the Developer tab > select Design Mode > Right-Click Text box > Cut

  • mathetes's avatar
    mathetes
    Silver Contributor
    Jan 31, 2020
    It looks like it could be a simple "Text Box" and if that's the case, you should be able to click on its frame and then hit your delete key. If that's not it, could you post the sheet itself (assuming nothing confidential is in it)

Resources