Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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" 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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 . |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Mysterious, undeletable zeros | Excel Discussion (Misc queries) | |||
*** Amazing Bra Deflects Gunshot **** | Excel Worksheet Functions | |||
How can I add active tick mark/check mark boxes in excel? | Excel Discussion (Misc queries) | |||
These templates are amazing! This really shows you care about us! | Excel Discussion (Misc queries) |