Editing in Cell

[Guest]

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

 

[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)

 

[Guest]

Or more directly:
View/Formula Bar
Bob Umlas

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)

 

[Guest]

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

 

[Guest]

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!

 

[Guest]

Thanks to everyone. Exactly what I was looking for.