Inserting Function blanks adjoioning cell

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

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
 
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
Click to expand...

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