How do I remove multiple lines in Formula Bar?

[bassplr19]

I can't figure out why or how to fix this problem, the formula bar seems to have sized itself to a certain width. It doesn't matter how I have my screen or the width of the cell I am editing...

 

[Logit]

Have you clicked the UP arrow in the upper right hand corner ?

 

[Alex Blakenburg]

Ctrl+Shift+U should work too.

 

[bassplr19]

Have you clicked the UP arrow in the upper right hand corner ?

The formula stays condensed horizontally, hence the expanded formula bar.

 

[FormR]

Hi, you probably have a line feed character in the tables column name.

 

[bassplr19]

Hi, you probably have a line feed character in the tables column name.

How do I check/find/fix that?

 

[bassplr19]

I just did some experimenting; I added a line feed to the header in Column L and the formula in Column M got all funky, WTF?

 

[FormR]

Hi, the formula bar is honouring the line feed characters. What's the problem exactly?

 

[bassplr19]

I have no line feed characters in my formula; I have to expand the formula bar to read the formulas, it's a little annoying.

The line feed characters are in a different column header than the formulas they are affecting, how is that useful?

 

[FormR]

The line feed character is in the name of the column, and the name of the column (including the linefeed character) is in the formula. Can you just remove the line feed characters? Obviously that will potentially have an impact on how the table header is displayed.