software

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.
ThanksPerhaps try clicking Tools gt; AutoCorrect
Look for the line Replace: A, With A/B
and delete it
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;Amstequot; gt; wrote in message
news
gt; In the spreadsheet I am working on, there is a heading of A/B; now
whenever I
gt; type a capital A in another cell it fills the cell with A/B; how can I get
gt; rid of this so that no previously typed data appears in another cell? I
have
gt; tried clearning cells but this does not work.
gt; Thanks
gt;
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 (Toolsgt;Optionsgt;Edit)
And at last, you always can copy the entry from another cell.--
Arvi Laanemets
( My real mail address: arvi.laanemetslt;atgt;tarkon.ee )
quot;Amstequot; gt; wrote in message
news
gt; In the spreadsheet I am working on, there is a heading of A/B; now
gt; whenever I
gt; type a capital A in another cell it fills the cell with A/B; how can I get
gt; rid of this so that no previously typed data appears in another cell? I
gt; have
gt; tried clearning cells but this does not work.
gt; Thanks
gt;
Amste,

When you type A and quot;A/Bquot; 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 MVPquot;Amstequot; gt; wrote in message
news
gt; In the spreadsheet I am working on, there is a heading of A/B; now whenever I
gt; type a capital A in another cell it fills the cell with A/B; how can I get
gt; rid of this so that no previously typed data appears in another cell? I have
gt; tried clearning cells but this does not work.
gt; Thanks
gt;
Thanks so much, I have removed the auto-complete, this seems to have worked
Thanks again.quot;Arvi Laanemetsquot; wrote:

gt; Hi
gt;
gt; One possible solution is to add a empty row below headers (and hide it)
gt; Another solution (probably it is the right one, I haven't checked it) is to
gt; turn AutoComplete off (Toolsgt;Optionsgt;Edit)
gt; And at last, you always can copy the entry from another cell.
gt;
gt;
gt; --
gt; Arvi Laanemets
gt; ( My real mail address: arvi.laanemetslt;atgt;tarkon.ee )
gt;
gt;
gt;
gt; quot;Amstequot; gt; wrote in message
gt; news
gt; gt; In the spreadsheet I am working on, there is a heading of A/B; now
gt; gt; whenever I
gt; gt; type a capital A in another cell it fills the cell with A/B; how can I get
gt; gt; rid of this so that no previously typed data appears in another cell? I
gt; gt; have
gt; gt; tried clearning cells but this does not work.
gt; gt; Thanks
gt; gt;
gt;
gt;
gt;