A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Undeletable mark--amazing properties



 
 
Thread Tools Display Modes
  #1  
Old June 1st, 2010, 02:44 AM
Don_Texas Don_Texas is offline
Member
 
First recorded activity by OfficeFrustration: Jun 2010
Posts: 3
Angry 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 (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?
  #2  
Old June 1st, 2010, 05:41 AM posted to microsoft.public.excel.misc
Jim Cone[_2_]
external usenet poster
 
Posts: 434
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  
Old June 1st, 2010, 05:44 AM posted to microsoft.public.excel.misc
Jacob Skaria
external usenet poster
 
Posts: 5,952
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  
Old June 1st, 2010, 04:36 PM
Don_Texas Don_Texas is offline
Member
 
First recorded activity by OfficeFrustration: Jun 2010
Posts: 3
Talking

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

Quote:
Originally Posted by Jacob Skaria View Post
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
.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


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


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