In the spreadsheet I am working on, there is a heading of A/B; now whenever I
type a capital A in another cell it fills the cell with A/B; how can I get
rid of this so that no previously typed data appears in another cell? I have
tried clearning cells but this does not work.
Thanks

Perhaps try clicking Tools AutoCorrect
Look for the line Replace: A, With A/B
and delete it
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Amste" wrote in message
...
In the spreadsheet I am working on, there is a heading of A/B; now
whenever I
type a capital A in another cell it fills the cell with A/B; how can I get
rid of this so that no previously typed data appears in another cell? I
have
tried clearning cells but this does not work.
Thanks

Hi

One possible solution is to add a empty row below headers (and hide it)
Another solution (probably it is the right one, I haven't checked it) is to
turn AutoComplete off (ToolsOptionsEdit)
And at last, you always can copy the entry from another cell.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"Amste" wrote in message
...
In the spreadsheet I am working on, there is a heading of A/B; now
whenever I
type a capital A in another cell it fills the cell with A/B; how can I get
rid of this so that no previously typed data appears in another cell? I
have
tried clearning cells but this does not work.
Thanks

Amste,

When you type A and "A/B" appears, press backspace to not accept the autocomplete suggestion (enter
will accept it). That is one drawback of autocomplete, but worth living with.

HTH,
Bernie
MS Excel MVP


"Amste" wrote in message
...
In the spreadsheet I am working on, there is a heading of A/B; now whenever I
type a capital A in another cell it fills the cell with A/B; how can I get
rid of this so that no previously typed data appears in another cell? I have
tried clearning cells but this does not work.
Thanks

Thanks so much, I have removed the auto-complete, this seems to have worked
Thanks again.


"Arvi Laanemets" wrote:

Hi

One possible solution is to add a empty row below headers (and hide it)
Another solution (probably it is the right one, I haven't checked it) is to
turn AutoComplete off (ToolsOptionsEdit)
And at last, you always can copy the entry from another cell.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"Amste" wrote in message
...
In the spreadsheet I am working on, there is a heading of A/B; now
whenever I
type a capital A in another cell it fills the cell with A/B; how can I get
rid of this so that no previously typed data appears in another cell? I
have
tried clearning cells but this does not work.
Thanks