Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I remove hidden empty text cells from Excel?
I have spreadsheets which contain empty text boxes that must have been
created by Excel itself. I can not display the boxes because they are empty and, therefore, can not see them to then delete them. I come acroos them by chance as I move the cursor. The problem I face is that the spreadsheets are duplicated frequently as masters and the hidden text boxes also duplicate and are building up significantly. Does anybody else have this problem and a cure ? Help please. |
#2
|
|||
|
|||
If by text boxes you mean empty comments, then select the entire worksheet
and pull-down: Edit Clear Comments -- Gary''s Student "Bill Z1P" wrote: I have spreadsheets which contain empty text boxes that must have been created by Excel itself. I can not display the boxes because they are empty and, therefore, can not see them to then delete them. I come acroos them by chance as I move the cursor. The problem I face is that the spreadsheets are duplicated frequently as masters and the hidden text boxes also duplicate and are building up significantly. Does anybody else have this problem and a cure ? Help please. |
#3
|
|||
|
|||
Or, if you actually do mean Text Boxes, do this: Click on Edit Go to Special Then click on Objects and then OK You now have all objects on the sheet highlighted. To move between them use the Tab key. Use the Delete key when you've got one highlighted that you don't want. -- Cutter ------------------------------------------------------------------------ Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848 View this thread: http://www.excelforum.com/showthread...hreadid=472429 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove portion of text from cells | Excel Discussion (Misc queries) | |||
Formula to strip figures from cells text strings | Excel Discussion (Misc queries) | |||
Cells formated as text do not always display properly | Excel Discussion (Misc queries) | |||
Display empty cells | Excel Discussion (Misc queries) | |||
Sumproduct ... Empty Cells vs Spaces? | Excel Discussion (Misc queries) |