Too big to fit in cell

  • Thread starter Thread starter Lars Brownies
  • Start date Start date
L

Lars Brownies

I have cell A1 with text that is too big to fit in the cell. Standard
behavior is that the text of A1 is fully visible spread over A1 and B1,
unless B1 is filled.

How do I tell Excel that the remains of cell A1 should not be shown in the
empty B1. In fact the remains should not be shown at all, so I also dont
wan't cel A1 to have 2 lines.

Thanks,

Lars
 
Hi Lars,

You could enter a single quote sign ' in B1. It will not show, and the text
in A1 will behaive as you want.

Best regards,
Per
 
Thanks. I was kinda hoping this could be done without entering extra data.

Lars
 
Back
Top