Editing in Cell

D

Dale Fye

This is probably a really stupid question.

I have a large amount of text in a group of cells on the first page of my
workbook. When I click in this group of merged cells, the text drops down
and is displayed in the fx textbox at the top of the page (which is great for
editing values or short functions, but is annoying when editing text). Is
there an option that turns this off when editing text? I've got the
EditInCell option checked in the Edit tab of the Options dialog, but that
doesn't prevent the text from dropping down and obscuring the text in the
cells I am trying to edit.

Dale
 
R

Ron Coderre

Try this:

From the Excel Main Menu:
<tools><options><view>.....UNcheck: Formula Bar

When you're done.....Check the box to view it again.

Is that something you can work with?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)
 
B

Bob Umlas, Excel MVP

Or more directly:
View/Formula Bar
Bob Umlas

Ron Coderre said:
Try this:

From the Excel Main Menu:
<tools><options><view>.....UNcheck: Formula Bar

When you're done.....Check the box to view it again.

Is that something you can work with?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)
Click to expand...
 
H

hmm

In Options, View tab, uncheck Show Formula Bar. You can then only edit by
double-clicking in the cell.
 
B

Bob Umlas, Excel MVP

Another possibility is to make the window size Normal (not maximized, not
minimized), then you can drag the window out of the way of the formula bar!
 
Top