Re: view source work*** when entering formula

Gord,
Not to argue with an MVP, but my experience with Excel exactly
matches JT's, and has on many different installations of Excel on many
different PCs. So is it a setting somewhere?

/ Tyla /


On Mar 21, 10:41 am, Gord Dibben <gorddibbATshawDOTca> wrote:
Tyla

I don't believe it is a feature and is notExceldefault behaviour.

You should be able to enter an = sign then switch to next *** and select a
cell then hit + key and keep selecting more cells in that *** until you hit
ENTER, at which time you will return to first ***.

Gord Dibben MSExcelMVP

On 20 Mar 2007 19:29:51 -0700, "Tyla" <tylagu...@xxxxxxxxxxx> wrote:

Thsi falls into the "Feature not a bug" category. It's defaultExcel
behavior, there's nothing wrong with your setup.
One way you might try is to create a second window to yourExcel
workbook ("Window / New Window" inExcel2003) then resize the two
windows so part of each is visible. Now you can start your formula in
one window while clicking on the cells you want to reference in the
second window. The standardExcelbehavior still occurs, but visually
things are easier to handle.

/ T /

On Mar 16, 9:49 am, JT <J...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
When I enter a simple formula, in my active ***, referencing another
work***: I hit the + sign and the view goes back to the original active
***.
I want to keep the view on my data source work*** and then when I hit
enter the view should go back to my active ***.
Sample: I hit the "=" sign to start the formula, click another work***,
click the cell to use, click the + sign and the view automatically reverts
back to my active ***. I have to keep clicking the data source work***
to add multiple cells from the data source.
What is wrong in myexcelsetup?

JT


.

Loading