ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Auto fill in (https://www.excelbanter.com/excel-discussion-misc-queries/125442-auto-fill.html)

TQ

Auto fill in
 
Hi,
I discover that when I type some word that already exist,just half way I
type the word then it will automatic show the following word in highlighted.

Is this setting problem ? If yes where should I choose the function ?


Gord Dibben

Auto fill in
 
ToolsOptionsEdit

Enable Autocomplete for Cell Values.

Check or uncheck. Whatever you want.


Gord Dibben MS Excel MVP

On Tue, 9 Jan 2007 18:21:01 -0800, TQ wrote:

Hi,
I discover that when I type some word that already exist,just half way I
type the word then it will automatic show the following word in highlighted.

Is this setting problem ? If yes where should I choose the function ?



Max

Auto fill in
 
Presuming you want to disable it ..
Click Tools Options Edit tab
Uncheck "Enable AutoComplete for cell values" OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"TQ" wrote:
Hi,
I discover that when I type some word that already exist,just half way I
type the word then it will automatic show the following word in highlighted.

Is this setting problem ? If yes where should I choose the function ?



All times are GMT +1. The time now is 03:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com