I’m wondering if there’s a way I can detect an end of an excel cell so that i can alt+enter my line. I don’t want my long sentences to ‘overwrite’ other cells. By the way, I have merged my cells, say from K to O and I just don’t want the extra words to appear overlapping cell P.
It’s there a way? Thanks in advance.
Subject: Change the cell property…
I believe all you have to do is set the cell “WrapText” property to True, and your text will wrap within the cell instead of increasing the cell’s width.
Subject: RE: Change the cell property…
oh ok…thanks…
Subject: RE: Change the cell property…
In addition to the wonderful tip from Terry you can also set the cell width to control exactly how wide you want it and then apply the wraptext to fit the text within the specified width.