Prev: Getting contents of adjacent cells
Next: Date Related Query
From: Don_Texas on 31 May 2010 21:43

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?




--
Don_Texas
From: Jim Cone on 1 Jun 2010 00:41


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"
<Don_Texas.64a2e19(a)officefrustration.com>
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?
--
Don_Texas
From: Jacob Skaria on 1 Jun 2010 00:44
Press F5 and click 'Special' and select 'Objects'>OK...whoch should select
all objects. Then press 'Delete' key

--
Jacob (MVP - Excel)


"Don_Texas" wrote:

>
> 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?
>
>
>
>
> --
> Don_Texas
> .
>
From: Don_Texas on 1 Jun 2010 11:36

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

Jacob Skaria;3739591 Wrote:
> Press F5 and click 'Special' and select 'Objects'OK...whoch should
> select
> all objects. Then press 'Delete' key
>
> --
> Jacob (MVP - Excel)
>
>
> "Don_Texas" wrote:
> -
>
> 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?
>
>
>
>
> --
> Don_Texas
> .
> -




--
Don_Texas
 | 
Pages: 1
Prev: Getting contents of adjacent cells
Next: Date Related Query