| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofile text box
When typing text into a cell, Excel will sometimes autofill in what I have
previously typed into another cell. If I have many cells to type, I do not want it auto filling. How do I stop Excel from doing this. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Autofile text box
If you mean that you have for instance type California in cell A2 then in A2
you want to type Canada but as soon you start it fills it with California? Normally it is actually a great help if you do a lot of text entries but it can be turned off at toolsoptionsedit and clear "enable autocomplete for cell values" -- Regards, Peo Sjoblom "Linda" wrote in message ... When typing text into a cell, Excel will sometimes autofill in what I have previously typed into another cell. If I have many cells to type, I do not want it auto filling. How do I stop Excel from doing this. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Autofile text box
Tools.OptionsEdit. Uncheck "enable autocomplete for cell values"
Thses instructions are for 2003 and earlier. Gord Dibben MS Excel MVP On Wed, 24 Sep 2008 12:58:00 -0700, Linda wrote: When typing text into a cell, Excel will sometimes autofill in what I have previously typed into another cell. If I have many cells to type, I do not want it auto filling. How do I stop Excel from doing this. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| grab cell text from multi-tab workbook, show text in another workb | Excel Worksheet Functions | |||
| Sumif text is contained winthin a longer text string in a cell | Excel Worksheet Functions | |||
| Text does not display in "Text boxs" and when wrapping text in a c | Excel Discussion (Misc queries) | |||
| Counting a mixed text/number column based on text in another colum | Excel Discussion (Misc queries) | |||
| merged cells into one text cell, size varies dependant on text dat | Excel Discussion (Misc queries) | |||
Hybrid Mode
