VBA code to auto adjust cells

[siddo]

Is there a vba code which can adjust the cell whenever we put a line break alt+enter and adjust the cell such that the data before line break is only to be seen

 

[XLfriend777]

Hi siddo. What I do to show just the top of the cell is to set the row height - to something like 15 and then adjust the vertical alignment to "Top Align". This can be done in VBA for individual rows or for an entire sheet. Hope this helps get you started.