ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Removing text (https://www.excelbanter.com/excel-programming/305318-removing-text.html)

frank

Removing text
 
I inherited a spreadsheet with what looks like a "text
box". The text is not tied to any particular cell, and I
cannot find a way to "select" it so that I can delete it.

I'd appreciate any suggestions on how I can delete this
text.

thank,Frank

tanner[_4_]

Removing text
 
hi

try making the visual basic toolbar visible:
[MENU]ViewToolbarsVisual Basic

then select then option for 'Design Mode' looks like a set square an
ruler. then you should be able to select and delete the text box. onc
done you can deseelct the design mode option and close the toolbar.

Hope this helps

--
Message posted from http://www.ExcelForum.com


frank

Removing text
 

That was the trick!!

Thanks, Frank


All times are GMT +1. The time now is 05:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com