Forum Discussion
Excel Unable To Merge Cells
I researched how to merge cells and align text but for some reason some of the cells in my spreadsheet aren't showing the full text to align right it's not displaying properly.
It depends on whether you want to extend the line height (wrapping text) or line width the text length. Various possibilities, also possible with VBA.
Here some links and a small VBA code for the automatic adjustment to the text of the cells.
Change the column width and row height
sIf you find yourself needing to expand or reduce Excel's row widths and column heights, there are several ways to adjust them.
VBA:
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
Target.EntireRow.AutoFit
Target.EntireColumn.AutoFit
End Sub
Example file is inserted.
Hope I was able to help you with this info.
I know I don't know anything (Socrates)
Was the answer useful? Mark them as helpful!
This will help all forum participants.