Excel Autocomplete?

Giganews Newsgroups
Subject: Excel Autocomplete?
Posted by:  Tom Kreutz (kreu…@princeton.edu)
Date: Mon, 20 Oct 2003

In Excel 2000 and 2002 (Windows 2000), while I'm typing a formula
into a cell, Excel frequently takes it upon itself to include a range of
cells in the formula.  Very annoying!

  For example, while typing "= B3 * 42", after I hit the "*" key, Excel
adds "11:11" to what I'm typing.  (I'm working on a cell in row 11.)

  Have I inadvertently asked Excel to do this by checking (or failing
to uncheck) an option somewhere?

  Many thanks,

Tom

Replies