Doesn't the autocomplete stay on for the entire application (all
workbooks)--once you toggle it on?

And doesn't it stay off for the entire application--once you toggle it off?

(Or am I misunderstanding something...)

FSPH wrote:

Hello there,

The command "Auto-Complete" can be enabled for cells of one workseet by
ticking off "Enable Auto-Complete" under Tools/Options/Edit.

Is there a way to enable this Auto-Complete on all or at least selected
worksheets?

I am using Excel 2002 (SP3) on Microsoft Vista.

Thank you for your help.

FSPH

--

Dave Peterson