Inserting Function blanks adjoioning cell
 

Occasionally, when I want to insert a cell address for a cell that is
immediately to the left of the one I am trying to put a formula in,
inserting the '=' sign blanks out both the cell I'm working on and the one
to the left. Of course, there are workarounds, but is there a way to not
have to 'work around' this problem?

Maybe I should add, often the cell in question is from another page, which
can make its address rather long.
Dave

Inserting Function blanks adjoioning cell
 

I'd just format the formula cell to left-justify temporarily, if required
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:15,700 Files:353 Subscribers:53
xdemechanik
---
"Dave" wrote:
Occasionally, when I want to insert a cell address for a cell that is
immediately to the left of the one I am trying to put a formula in,
inserting the '=' sign blanks out both the cell I'm working on and the one
to the left. Of course, there are workarounds, but is there a way to not
have to 'work around' this problem?

Maybe I should add, often the cell in question is from another page, which
can make its address rather long.
Dave

Inserting Function blanks adjoioning cell
 

Thanks Max - I'll give that a try

Dave


"Max" wrote in message
...
I'd just format the formula cell to left-justify temporarily, if required
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:15,700 Files:353 Subscribers:53
xdemechanik
---
"Dave" wrote:
Occasionally, when I want to insert a cell address for a cell that is
immediately to the left of the one I am trying to put a formula in,
inserting the '=' sign blanks out both the cell I'm working on and the
one
to the left. Of course, there are workarounds, but is there a way to not
have to 'work around' this problem?

Maybe I should add, often the cell in question is from another page,
which
can make its address rather long.
Dave

Inserting Function blanks adjoioning cell
 

Welcome, Dave.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 15,500, Files: 352, Subscribers: 53
xdemechanik
---
"Dave" wrote in message
...
Thanks Max - I'll give that a try

Dave

Inserting Function blanks adjoioning cell
 

On Jul 11, 8:53 pm, "Dave" wrote:
Occasionally, when I want to insert a cell address for a cell that is
immediately to the left of the one I am trying to put a formula in,
inserting the '=' sign blanks out both the cell I'm working on and the one
to the left. Of course, there are workarounds, but is there a way to not
have to 'work around' this problem?

Maybe I should add, often the cell in question is from another page, which
can make its address rather long.
Dave

If I'm understanding you correctly, you could also turn off "Edit
directly in cell" in the Options.