Excel thinks it knows the formula I want

  • Thread starter Thread starter Tim Zych
  • Start date Start date
T

Tim Zych

In cell B1 type in the formula "=A1 & A2" as quickly as
possible. When I do it on an XL2000 SR1 machine,
Excel "takes over" the formula and returns "=A1 &1:1"
after I type tye ampersand.

Why is this and is it possible to turn this "smart"
feature off?
 
Tim,

I've never seen that happen in any version of Excel, but it could be caused
by a sticky shift key. SHIFT+SPACE is the shortcut to select an entire row,
so when you type the ampersand (which requires SHIFT) and then hit space,
perhaps your shift key is still down.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Tim,

It's because you don't release the shift key after typing the & and pressing
the spacebar. Do it myself all the time.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top