Go Back   AnandTech Forums > Software > Software for Windows

Forums
· Hardware and Technology
· CPUs and Overclocking
· Motherboards
· Video Cards and Graphics
· Memory and Storage
· Power Supplies
· Cases & Cooling
· SFF, Notebooks, Pre-Built/Barebones PCs
· Networking
· Peripherals
· General Hardware
· Highly Technical
· Computer Help
· Home Theater PCs
· Consumer Electronics
· Digital and Video Cameras
· Mobile Devices & Gadgets
· Audio/Video & Home Theater
· Software
· Software for Windows
· All Things Apple
· *nix Software
· Operating Systems
· Programming
· PC Gaming
· Console Gaming
· Distributed Computing
· Security
· Social
· Off Topic
· Politics and News
· Discussion Club
· Love and Relationships
· The Garage
· Health and Fitness
· Home and Garden
· Merchandise and Shopping
· For Sale/Trade
· Hot Deals with Free Stuff/Contests
· Black Friday 2014
· Forum Issues
· Technical Forum Issues
· Personal Forum Issues
· Suggestion Box
· Moderator Resources
· Moderator Discussions
   

Reply
 
Thread Tools
Old 08-30-2009, 07:04 PM   #1
fuzzybabybunny
Moderator
Digital & Video Cameras
 
fuzzybabybunny's Avatar
 
Join Date: Jan 2006
Posts: 9,434
Default How do I get this text box off my excel spreadsheet?

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?
__________________
I love everyone, and everyone includes you!

Working on vacation.

"Don't do it, you'll die FBB." - ViviTheMage
fuzzybabybunny is offline   Reply With Quote
Old 08-30-2009, 07:40 PM   #2
bruceb
Diamond Member
 
bruceb's Avatar
 
Join Date: Aug 2004
Location: Wayne, New Jersey
Posts: 7,188
Default How do I get this text box off my excel spreadsheet?

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.
bruceb is offline   Reply With Quote
Old 08-30-2009, 07:42 PM   #3
fuzzybabybunny
Moderator
Digital & Video Cameras
 
fuzzybabybunny's Avatar
 
Join Date: Jan 2006
Posts: 9,434
Default How do I get this text box off my excel spreadsheet?

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.
__________________
I love everyone, and everyone includes you!

Working on vacation.

"Don't do it, you'll die FBB." - ViviTheMage
fuzzybabybunny is offline   Reply With Quote
Old 08-31-2009, 12:55 AM   #4
mayest
Senior Member
 
Join Date: Jun 2006
Posts: 306
Default How do I get this text box off my excel spreadsheet?

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.
mayest is offline   Reply With Quote
Old 03-04-2013, 08:56 PM   #5
zacbelle
Junior Member
 
Join Date: Mar 2013
Posts: 1
Default

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.
zacbelle is offline   Reply With Quote
Old 06-21-2013, 06:29 AM   #6
zzoom
Junior Member
 
Join Date: Jun 2013
Posts: 1
Default

Easy solution here:

http://zzoomforward.blogspot.co.uk/2...ox-or-any.html

Regards,
Zzoom

Last edited by zzoom; 06-21-2013 at 06:30 AM. Reason: Wrong address
zzoom is offline   Reply With Quote
Old 09-16-2013, 01:27 PM   #7
Scharfschutzen
Junior Member
 
Join Date: Sep 2013
Posts: 2
Default Need another solution

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!

Scharfschutzen is offline   Reply With Quote
Old 09-17-2013, 01:35 PM   #8
Scharfschutzen
Junior Member
 
Join Date: Sep 2013
Posts: 2
Default

bump
Scharfschutzen is offline   Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 07:16 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.