Macro to insert a Line break at the end of the text of the cell in excel file

[ramindya]

Hello,

To manually insert a line break at the end of the text of the cell in excel file the solution is "ALT + Enter"
But I like to create a macro in the excel file which will do same but to the entire column.

Thanks,
Ram

 

[venkat1926]

try this

in excel 2007 there is an icon "wrap text" under alignment (first line last item) in ribbon "home"

select the cells required (not just a column) and click wrap text