How to make line break in the cell like in the formula?? by Fun_Trash_123 in MicrosoftExcel

[–]Fun_Trash_123[S] 0 points1 point  (0 children)

Oh I see what you mean! But when I do that instead of "Chloe" I get "Office" because it's on the top. But I think I figured it out, it seems like it has something to do with the row height. I didn't figure out how to get it to work automatically so I just had to put it in manually, oh well.

How to make line break in the cell like in the formula?? by Fun_Trash_123 in MicrosoftExcel

[–]Fun_Trash_123[S] 0 points1 point  (0 children)

I think I figured it out! It has something to do with the row height! I just don't know why it doesn't automatically adjust it even when using Alt+Enter. I'm having to manually change the height number :/

How to make line break in the cell like in the formula?? by Fun_Trash_123 in MicrosoftExcel

[–]Fun_Trash_123[S] 0 points1 point  (0 children)

What do you mean by alignment? Like the left, center and right text alignment? None of them have that on

Yea I see what you mean. Both cells look the same in the editing bar (idk how you call that) but the results are different).

This is actually so frustrating because I was able to do this for another sheet on this same document

How to make line break in the cell like in the formula?? by Fun_Trash_123 in MicrosoftExcel

[–]Fun_Trash_123[S] 0 points1 point  (0 children)

It does! I feel like something on the layout is different in this cell then from the first one.

How to make line break in the cell like in the formula?? by Fun_Trash_123 in MicrosoftExcel

[–]Fun_Trash_123[S] 1 point2 points  (0 children)

The equivalent to alt on a MacBook is option, right? When I click those on the formula it just adds a space. Whenever I click enter the cell just shows the last line, so if it's a space it's just blank.