Formula bar drop-down

[TCEBob]

Some cells have extended info or long formulae. If the cursor is on such a cell
the formula edit area drops down to accommodate the contents. If I need to
access the columns row (say, to tweak the width) or read the topmost data rows
this is an inconvenience. Is there a means of restricting the edit bar to one
line unless the cursor is actually in it. Maybe a keyboard toggle?

rs

 

[Gord Dibben]

rs

Several work-arounds.

See google search results.

http://snipurl.com/9ier

http://snipurl.com/9iet

Gord Dibben Excel MVP

 

[TCEBob]

Thanks much! Maybe I'll make a macro to hide/unhide the bar with an F-key. I
think the suggestion of a split window is clever but cumbersome.

rs

 

[Gord Dibben]

That's me. Clumbver<g>

The ALT V F is close to a macro.

So's View>Formula Bar

Gord