Excel Insert Typing field has disappeared

D

Diamond Girl

Hi there.
This may sound a little silly, however, the field that I use to type
information into (so it transfers the copy into the selected field), has
disappeared and I don't know how to retrieve it. For example: if I have a c
ell with, say, 20 words typed into it and one word is misspelt, I have to
retyped the entire sentence, inside the actual cell, to fix the error. I
don't have the field at the top of the screen that shows the copy, so I can't
place the cursor where the error is and then fix it, so it then fixes itself
in the cell (I hope this makes sense).
How do I retrieve this field?
Thanks for your time.
 
R

Rick Rothstein \(MVP - VB\)

Does clicking View/Formula Bar on Excel's menu bar bring it back?

Rick
 
B

bnmohan via OfficeKB.com

Hi Diamond Girl

You could also double click on the cell that you wish to edit.
If that does not work, Tools->options->edit->tick edit directly in cell (
which is the default setting for Excel)

Mohan
Does clicking View/Formula Bar on Excel's menu bar bring it back?

Rick
Hi there.
This may sound a little silly, however, the field that I use to type
Click to expand...
[quoted text clipped - 10 lines]
How do I retrieve this field?
Thanks for your time.
Click to expand...
Click to expand...
 
Top