How do I get this text box off my excel spreadsheet?

Discussion in 'Software for Windows' started by fuzzybabybunny, Aug 30, 2009.

  1. fuzzybabybunny

    fuzzybabybunny Moderator<br>Digital & Video Cameras
    Moderator

    Joined:
    Jan 2, 2006
    Messages:
    10,075
    Likes Received:
    3
    I was copying and pasting values into the spreadsheet and I accidentally pasted in a text input box from the website. Now it won't go away.

    1. Can't right click and delete it.
    2. Deleting the cell doesn't do anything.
    3. Deleting the entire row/column doesn't do anything.
    4. Closing and reopening document doesn't do anything.

    http://www.victorlinphoto.com/...loads/exceltextbox.JPG

    WTF?
     
  2. Loading...

    Similar Threads - text excel spreadsheet Forum Date
    Having an Excel problem - text wrap. Screenshot Software for Windows Feb 22, 2014
    Excel Spreadsheet -- total text columns Software for Windows Oct 8, 2013
    Excel 2003 - how to add text as a prefix to another cell? Software for Windows Mar 26, 2009
    excel help please, how to not have text in cell spill over to adjacent cell Software for Windows Dec 10, 2008
    Excel: Text to column Software for Windows Sep 30, 2008

  3. bruceb

    bruceb Diamond Member

    Joined:
    Aug 20, 2004
    Messages:
    8,116
    Likes Received:
    13
    Delete a text box

    * Click the border of the text box that you want to delete, and then press DELETE.

    Make sure that the pointer is not inside the text box, but rather on the border of the text box. If the pointer is not on the border, pressing DELETE will delete the text inside the text box and not the text box.

    If that does not work, open up another spreadsheet and copy over the info
    from the bad sheet to the new sheet (carefully avoiding the text entry box)

    Then save the new spreadsheet. Delete the old one and if needed, rename the new one.
     
  4. fuzzybabybunny

    fuzzybabybunny Moderator<br>Digital & Video Cameras
    Moderator

    Joined:
    Jan 2, 2006
    Messages:
    10,075
    Likes Received:
    3
    There is no border to select. It's a really frickin' weird text box. Like the type that you'd find as part of a form on a website.

    Anyway, I simply copied all the contents of the spreadsheet and pasted it into a new spreadsheet. The text box thing didn't come along thankfully.
     
  5. mayest

    mayest Senior member

    Joined:
    Jun 30, 2006
    Messages:
    306
    Likes Received:
    0
    I guess it is too late now, but that looks like Excel 2007. You can go to the Page Layout tab and click the Selection Pane button. That will open a sidebar with all of the worksheet shapes. From there you can select any object and then press the delete button to get rid of it.
     
  6. zacbelle

    zacbelle Junior Member

    Joined:
    Mar 4, 2013
    Messages:
    1
    Likes Received:
    0
    I had exact same problem in Excel 2010 and can confirm the page layout tab fix from "mayest" worked. I wasn't able to delete the box but you can make it invisible.
     
  7. zzoom

    zzoom Junior Member

    Joined:
    Jun 21, 2013
    Messages:
    1
    Likes Received:
    0
    #6 zzoom, Jun 21, 2013
    Last edited: Jun 21, 2013
  8. Scharfschutzen

    Scharfschutzen Junior Member

    Joined:
    Sep 16, 2013
    Messages:
    2
    Likes Received:
    0
    I'm having, what I feel, is a similar issue.

    I have, what LOOKS like a comment box containing text on my excel.
    It's only view-able when I select certain cells (All the cells selected have the same comment--not sure if it's coincidence or copy/pasta.)

    I can move around the "comment" but cannot delete it. Pressing "Delete" on my keyboard clears the cell selected.

    Going into design mode yields no results.

    Here is an example of the document. I can email it upon request.
    Thank you in advanced! ;)

    [​IMG]
     
  9. Scharfschutzen

    Scharfschutzen Junior Member

    Joined:
    Sep 16, 2013
    Messages:
    2
    Likes Received:
    0
  10. Zug

    Zug Junior Member

    Joined:
    Dec 22, 2016
    Messages:
    1
    Likes Received:
    0
    Well, that is a necropost alright, but if someone will run into the same problem: this is Data Validation "thingie". In order to remove it select all cells, that have this feature enabled, go to "Data" tab, click on "Data Validation" button, switch to "Input Message" tab and press "Clear All" and "OK" buttons.