LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3
Default HIDDEN TEXT BOX IN EXCEL

As part of my job, I am required to perform spellchecks on worksheet pages of
excel files (financial statements). These worksheet pages contain many text
boxes. From time-to-time I run across a situation where spellcheck will find
a misspelled word that does not exist in any of the text boxes that are
visible on that worksheet, but may have been visible at one time. I think
the problem is that the accountant that created the excel file wanted to
delete certain text boxes and thought that he had done so, but never really
did delete them. Instead, he deleted the rows contained the text box, which
basically collapsed the text box. Now, I CANNOT find these text boxes! I
sometimes mistakenly find these collapsed text boxes by hovering over them
with my cursor, which detects them by changing shape. Unfortunately, all
text boxes in these excel files have been formatted to have NO FILL and NO
LINE, which makes them impossible to find (invisible)!

Please help me figure out how to find text boxes that have been collapsed or
made so small that they are the size of a pinpoint.

--
Margot
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
2007 Excel: text in cell becomes hidden when formatted to wrap tex Ross Excel Discussion (Misc queries) 0 June 6th 08 11:46 PM
Excel should let me use hidden text (like MS Word) - Thanks Les Excel Worksheet Functions 5 December 30th 05 09:02 PM
Excel. I am having a problem with hidden text SHR77 Excel Discussion (Misc queries) 1 November 22nd 05 04:03 PM
How can I remove hidden empty text cells from Excel? Bill Z1P Excel Worksheet Functions 2 October 2nd 05 08:04 PM
Why is my text hidden behind other cells? dANA Excel Discussion (Misc queries) 1 September 22nd 05 07:37 PM


All times are GMT +1. The time now is 04:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"