Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Undeletable mark--amazing properties


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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,549
Default Undeletable mark--amazing properties



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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,520
Default Undeletable mark--amazing properties

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Undeletable mark--amazing properties


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mysterious, undeletable zeros Frustrated Word User[_4_] Excel Discussion (Misc queries) 2 December 4th 08 04:16 PM
*** Amazing Bra Deflects Gunshot **** macca[_2_] Excel Worksheet Functions 3 November 8th 08 03:49 PM
How can I add active tick mark/check mark boxes in excel? gerberelli Excel Discussion (Misc queries) 2 May 3rd 08 05:16 PM
These templates are amazing! This really shows you care about us! PatHaugen Excel Discussion (Misc queries) 0 June 17th 05 12:57 AM


All times are GMT +1. The time now is 11:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"