mysterious red line

  • Thread starter Thread starter Mary
  • Start date Start date
M

Mary

I have a red line that I can not find how to eliminate.
It starts in a middle of one cell and flows thru two cells
to the middle of the fourth cell. If I place the cusor
below the line then click freeze pane it goes away. But
comes back when I unfreeze pane. It's located in the
middle of the spreadsheet. (Middle of b17 thru middle of
e17)
 
It may be a squished combo box or text box.

Choose View>Toolsbars>Control toolbox
Click the Design mode button
Point to the red line
If the pointer changes to a four-headed arrow, click on the line
to select it
Press the delete key, to delete the line

Click the Exit Design Mode button
Close the Control toolbox.
 
Thanks for your help!
-----Original Message-----
It may be a squished combo box or text box.

Choose View>Toolsbars>Control toolbox
Click the Design mode button
Point to the red line
If the pointer changes to a four-headed arrow, click on the line
to select it
Press the delete key, to delete the line

Click the Exit Design Mode button
Close the Control toolbox.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.
Click to expand...
 
Back
Top