Excel Autocomplete?

  • Thread starter Thread starter Tom Kreutz
  • Start date Start date
T

Tom Kreutz

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
 
I don't think it's excel. I have the same problem and it's my heavy fingers.
(Or my slow release of the shift key.)

I think you're hitting shift-Space bar which selects the row.

try this to see if it brings back muscle memories:

=*shift-spacebar
and you'll see something like:
=*15:15
 
Dear Dave,

Yes, of course. Thank you!! It also occurs occasionally whenever I
type...and so naturally it happens in Excel too.

Thanks for your help.

Tom
 
Back
Top