Undeletable mark--amazing properties

D

Don_Texas

A mysterious, undeletable mark appeared in an Excel 2003 spreadsheet. I
looks like a forward slash, but half-length and more sloped (45-deg.)
It won't delete, but it copies to other cells and to an empt
spreadsheet! (copy available). Writing in or pasting to the cell merel
overlays the mark, and doesn't replace it. It does not show in th
formula-data entry box (fx). Font color cannot be changed from black. I
is left justified, independent of cell width, and won't forma
center-justified or right-justified. It remains after saving an
reopening the spreadsheet. Any clues how to get rid of this
 
J

Jim Cone

Have you tried just deleting the row or column that it is in?
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware





"Don_Texas"
<[email protected]>
wrote in message
A mysterious, undeletable mark appeared in an Excel 2003 spreadsheet. It
looks like a forward slash, but half-length and more sloped (45-deg.).
It won't delete, but it copies to other cells and to an empty
spreadsheet! (copy available). Writing in or pasting to the cell merely
overlays the mark, and doesn't replace it. It does not show in the
formula-data entry box (fx). Font color cannot be changed from black. It
is left justified, independent of cell width, and won't format
center-justified or right-justified. It remains after saving and
reopening the spreadsheet. Any clues how to get rid of this?
 
J

Jacob Skaria

Press F5 and click 'Special' and select 'Objects'>OK...whoch should select
all objects. Then press 'Delete' key
 
D

Don_Texas

Yeah! Perfect! Selecting the mark in one cell simultaneously selects al
copies of the mark in other cells, surprising to me.--Don_Texas
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

data in X:XX format 23

Top