Cursor now appearing in formula bar, no longer in cell
 

Somehow I have lost the ability to edit cells after hitting F2 in a cell. I
am no longer getting the cursor that allows me to edit inputs within the
cell, instead the cursor shows up in the formula bar. Can someone please let
me know how to get the cursor back down to the cell? Thanks!

Cursor now appearing in formula bar, no longer in cell
 

There is an Option setting that governs this.
In XL 2003: Tools | Option
In XL 2007: Office tool (colourful circle) | Excel Options (bottom of the
Office dialog)
best wishes
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP

"CJC093101" wrote in message
...
Somehow I have lost the ability to edit cells after hitting F2 in a cell.
I
am no longer getting the cursor that allows me to edit inputs within the
cell, instead the cursor shows up in the formula bar. Can someone please
let
me know how to get the cursor back down to the cell? Thanks!

Cursor now appearing in formula bar, no longer in cell
 

Tools Options Edit and check allow edit in cells
--
Gary''s Student - gsnu200909


"CJC093101" wrote:

Somehow I have lost the ability to edit cells after hitting F2 in a cell. I
am no longer getting the cursor that allows me to edit inputs within the
cell, instead the cursor shows up in the formula bar. Can someone please let
me know how to get the cursor back down to the cell? Thanks!