Excel Ribbon

[T. Valko]

From a purely aesthetic point of view, the best thing about Excel 2007 is that the formula bar no longer infringes into the grid.

 

[hrlngrv]

It'd be better if it had a setting to grow to as many lines as possible to show the formula.

 

[Firefly2012]

One of the few things Excel 2007 got right was adding [Ctrl]+[Alt]+V as a shortcut for Paste Special, though arguably not quite as good as Star/Open/LibreOffice Calc's [Shift]+[Ctrl]+V shortcut.

Did you mean Ctrl+Alt+v,v because Ctrl+Alt+v only brings up the pastespecial dialog for me in 2007. It's a quicker option than Alt+e,s,v though (or Alt+h,v,v) although the position of the keys is a pita.

 

[Firefly2012]

It'd be better if it had a setting to grow to as many lines as possible to show the formula.

Agreed.

 

[T. Valko]

It'd be better if it had a setting to grow to as many lines as possible to show the formula.

Agreed

 

[Gerald Higgins]

It'd be better if it had a setting to grow to as many lines as possible to show the formula.

I thought 2007 DOES have that . . .

Double down arrows to the right of the formula box ?
Or click and drag the thin grey line above the column header letters ?
Or are we talking about something else ?

 

[hrlngrv]

I should have added the word automatically. You can manually set the number of lines in the formula bar, or scroll it, or collapse it to a single line, but there's no setting to display all of a really long formula automatically, i.e., almost in the same way Excel 2003 and prior do - just not hiding column headings.

 

[Gerald Higgins]

Oh I see. I'll have to look again in 2003, I don't use it much these days, but I THINK that's a small thing I actually prefer about 2007.

 

[hrlngrv]

I'd agree that preventing formulas from expanding over column headers in the worksheet frame is useful, but that was accomplished by making the size of the formula bar static except for manual, interactive resizing. If that's what you'd prefer, fine. However, I'd like an option (which you wouldn't need to use) which would tell the formula bar to resize automatically in order to show all cell contents.

 

[Colin Legg]

If it automatically resized would you still want it to shift the entire grid though? I can just picture the grid wobbling up and down as I tab across a row. I'd hate that.