How to point to (select) a cell to the left from a cell where I enter the = equal sign?

Hello!
How to point to (select) a cell to the left from a cell where I enter the =
equal sign? Clicking on it does not select it.
Best regards,
Dima

I'm not sure what yo're trying to do Dmitry. If you type a equal sign in a
cell you are commencing to enter a formula.....and then if you left-click on
another cell and then press Enter, you have just asked Excel to bring the
value from that other cell and place it in the cell where you typed the equal
sign. This is a short-cut method instead of having to type the other cells
address. If this is not what you're trying to do, then please post back with
more details.

hth
Vaya con Dios,
Chuck, CABGx3



"Dmitry" wrote:

> Hello!
> How to point to (select) a cell to the left from a cell where I enter the =
> equal sign? Clicking on it does not select it.
> Best regards,
> Dima
>
>
>

Thanks Vaya con Dios for replying.
Yes, this is what I'm trying to do. But clicking on the cell to the left
does not select it and does not enter it's address to the formula. This
happens to some cells with data sometimes.
"CLR" <CLR@discussions.microsoft.com> сообщил/сообщила в новостях следующее:
news:01110363-363A-44FF-8AF8-2614258F4DCC@microsoft.com...
> I'm not sure what yo're trying to do Dmitry. If you type a equal sign in
a
> cell you are commencing to enter a formula.....and then if you left-click
on
> another cell and then press Enter, you have just asked Excel to bring the
> value from that other cell and place it in the cell where you typed the
equal
> sign. This is a short-cut method instead of having to type the other
cells
> address. If this is not what you're trying to do, then please post back
with
> more details.
>
> hth
> Vaya con Dios,
> Chuck, CABGx3
>
>
>
> "Dmitry" wrote:
>
> > Hello!
> > How to point to (select) a cell to the left from a cell where I enter
the =
> > equal sign? Clicking on it does not select it.
> > Best regards,
> > Dima
> >
> >
> >

You should be able to Left-click on A1, type AAA and press Enter. Then
Left-click on B1 and press = and then Left-click on A1 again and press Enter.
AAA should show up in B1, and the formula =A1 should show up in the formula
Bar when B1 is selected. If you cannot do this, then something is wrong. To
determine if the problem is with the file, or with your computer, try moving
the file to another computer and see if the problem moves with it. Also, try
opening a brand new Excel file on your computer and trying the above
exercize. If it don't work, then the problem is with your computer or your
install of Excel.

hth
Vaya con Dios,
Chuck, CABGx3



"Dmitry" wrote:

> Thanks Vaya con Dios for replying.
> Yes, this is what I'm trying to do. But clicking on the cell to the left
> does not select it and does not enter it's address to the formula. This
> happens to some cells with data sometimes.
> "CLR" <CLR@discussions.microsoft.com> ц⌠ц▐ц▐ц┌ц²ц┴ц▄/ц⌠ц▐ц▐ц┌ц²ц┴ц▄ц│ ц≈ ц▌ц▐ц≈ц▐ц⌠ц■ц▒ц┬ ц⌠ц▄ц┘ц└ц∙ц─ц²ц┘ц┘:
> news:01110363-363A-44FF-8AF8-2614258F4DCC@microsoft.com...
> > I'm not sure what yo're trying to do Dmitry. If you type a equal sign in
> a
> > cell you are commencing to enter a formula.....and then if you left-click
> on
> > another cell and then press Enter, you have just asked Excel to bring the
> > value from that other cell and place it in the cell where you typed the
> equal
> > sign. This is a short-cut method instead of having to type the other
> cells
> > address. If this is not what you're trying to do, then please post back
> with
> > more details.
> >
> > hth
> > Vaya con Dios,
> > Chuck, CABGx3
> >
> >
> >
> > "Dmitry" wrote:
> >
> > > Hello!
> > > How to point to (select) a cell to the left from a cell where I enter
> the =
> > > equal sign? Clicking on it does not select it.
> > > Best regards,
> > > Dima
> > >
> > >
> > >
>
>
>

Does this occur on just one sheet?

Maybe the sheet is protected and you are not allowed to select locked or
unlocked cells?


Gord Dibben MS Excel MVP

On Thu, 29 Jun 2006 17:30:35 +0400, "Dmitry" <kopn@bk.ruDelete> wrote:

>Thanks Vaya con Dios for replying.
>Yes, this is what I'm trying to do. But clicking on the cell to the left
>does not select it and does not enter it's address to the formula. This
>happens to some cells with data sometimes.
>"CLR" <CLR@discussions.microsoft.com> сообщил/сообщила в новостях следующее:
>news:01110363-363A-44FF-8AF8-2614258F4DCC@microsoft.com...
>> I'm not sure what yo're trying to do Dmitry. If you type a equal sign in
>a
>> cell you are commencing to enter a formula.....and then if you left-click
>on
>> another cell and then press Enter, you have just asked Excel to bring the
>> value from that other cell and place it in the cell where you typed the
>equal
>> sign. This is a short-cut method instead of having to type the other
>cells
>> address. If this is not what you're trying to do, then please post back
>with
>> more details.
>>
>> hth
>> Vaya con Dios,
>> Chuck, CABGx3
>>
>>
>>
>> "Dmitry" wrote:
>>
>> > Hello!
>> > How to point to (select) a cell to the left from a cell where I enter
>the =
>> > equal sign? Clicking on it does not select it.
>> > Best regards,
>> > Dima
>> >
>> >
>> >
>

Thanks Vaya con Dios for your suggestions.
Yes, the problem is with the file to another computer. The problem does not
exists with a brand new Excel file. How to prevent the problem happening?
The problem happens from time to time with different files.
"CLR" <CLR@discussions.microsoft.com> сообщил/сообщила в новостях следующее:
news:017249C9-780E-4C99-920D-06E3CA448EF5@microsoft.com...
> You should be able to Left-click on A1, type AAA and press Enter. Then
> Left-click on B1 and press = and then Left-click on A1 again and press
Enter.
> AAA should show up in B1, and the formula =A1 should show up in the
formula
> Bar when B1 is selected. If you cannot do this, then something is wrong.
To
> determine if the problem is with the file, or with your computer, try
moving
> the file to another computer and see if the problem moves with it. Also,
try
> opening a brand new Excel file on your computer and trying the above
> exercize. If it don't work, then the problem is with your computer or
your
> install of Excel.
>
> hth
> Vaya con Dios,
> Chuck, CABGx3
>
>
>
> "Dmitry" wrote:
>
> > Thanks Vaya con Dios for replying.
> > Yes, this is what I'm trying to do. But clicking on the cell to the left
> > does not select it and does not enter it's address to the formula. This
> > happens to some cells with data sometimes.
> > "CLR" <CLR@discussions.microsoft.com> OIIAYEI/OIIAYEIA ? II?IOONE
OIAAOAYAA:
> > news:01110363-363A-44FF-8AF8-2614258F4DCC@microsoft.com...
> > > I'm not sure what yo're trying to do Dmitry. If you type a equal sign
in
> > a
> > > cell you are commencing to enter a formula.....and then if you
left-click
> > on
> > > another cell and then press Enter, you have just asked Excel to bring
the
> > > value from that other cell and place it in the cell where you typed
the
> > equal
> > > sign. This is a short-cut method instead of having to type the other
> > cells
> > > address. If this is not what you're trying to do, then please post
back
> > with
> > > more details.
> > >
> > > hth
> > > Vaya con Dios,
> > > Chuck, CABGx3
> > >
> > >
> > >
> > > "Dmitry" wrote:
> > >
> > > > Hello!
> > > > How to point to (select) a cell to the left from a cell where I
enter
> > the =
> > > > equal sign? Clicking on it does not select it.
> > > > Best regards,
> > > > Dima
> > > >
> > > >
> > > >
> >
> >
> >

Thanks Gord Dibben for replying.
Yes, now this occurs on just one sheet. The sheet is not protected. How to
prevent the problem happening? The problem happens from time to time with
different files.
"Gord Dibben" <gorddibbATshawDOTca> ???????/???????? ? ???????? ?????????:
news:qjn7a29ek4471gfckkjsc7br5rkvp6s9tb@4ax.com...
> Does this occur on just one sheet?
>
> Maybe the sheet is protected and you are not allowed to select locked or
> unlocked cells?
>
>
> Gord Dibben MS Excel MVP
>
> On Thu, 29 Jun 2006 17:30:35 +0400, "Dmitry" <kopn@bk.ruDelete> wrote:
>
> >Thanks Vaya con Dios for replying.
> >Yes, this is what I'm trying to do. But clicking on the cell to the left
> >does not select it and does not enter it's address to the formula. This
> >happens to some cells with data sometimes.
> >"CLR" <CLR@discussions.microsoft.com> сообщил/сообщила в новостях
следующее:
> >news:01110363-363A-44FF-8AF8-2614258F4DCC@microsoft.com...
> >> I'm not sure what yo're trying to do Dmitry. If you type a equal sign
in
> >a
> >> cell you are commencing to enter a formula.....and then if you
left-click
> >on
> >> another cell and then press Enter, you have just asked Excel to bring
the
> >> value from that other cell and place it in the cell where you typed the
> >equal
> >> sign. This is a short-cut method instead of having to type the other
> >cells
> >> address. If this is not what you're trying to do, then please post
back
> >with
> >> more details.
> >>
> >> hth
> >> Vaya con Dios,
> >> Chuck, CABGx3
> >>
> >>
> >>
> >> "Dmitry" wrote:
> >>
> >> > Hello!
> >> > How to point to (select) a cell to the left from a cell where I enter
> >the =
> >> > equal sign? Clicking on it does not select it.
> >> > Best regards,
> >> > Dima
> >> >
> >> >
> >> >
> >
>