Excel Ribbon

[hrlngrv]

I'd like to have the option of seeing whether or not I could live with the frame shifting up and down. I can simulate this functionality crudely with

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  Application.FormulaBarHeight = 1 + Len(ActiveCell.Formula) \ 120
End Sub

which works OK with my screen resolution and default font, but it could get messed up with some proportional fonts.

I could live with a downward pointing arrow at the right end of the formula bar which expanded from 1 line to as many lines as needed to view the whole formula rather than just expanding to the last number of lines manually set. Or at least a right-click option with options for collapsed, last number of rows set manually (current left-click behavior) or all rows needed to display the entire cell contents.

I wouldn't use this all the time, only when writing/editing formulas. A lot of the time what cells are displaying is more important that what they contain, but sometimes what they contain is more important.

 

[Firefly2012]

That's a fair point Colin but that would be the beauty of having the option - you could choose which approach you prefer for the workbook at hand.

 

[Colin Legg]

I could live with a downward pointing arrow at the right end of the formula bar which expanded from 1 line to as many lines as needed to view the whole formula rather than just expanding to the last number of lines manually set.

Yes, I agree that that would be a welcome (and very simple) improvement.