Too big to fit in cell

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
 
P

Per Jessen

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
 
L

Lars Brownies

Thanks. I was kinda hoping this could be done without entering extra data.

Lars
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top