Menu
I have 3 cells that I want to use as 1 comment line. Is there a way to combine them into 1 cell so I can write a whole sentence across?
Example:
| content | content | content |
I want to turn it into one cell without those cell separators:
| content content content |
864
Right-click the selected cells and click Merge Cells.
Generally, every cell in a row or column has the same size, so you can't adjust the size of a cell individually without affecting the others in its same row or column. You can merge adjacent cells to create larger compound cells, however, and you can set rows and columns to automatically adjust to fit text.
Click in a cell, or select multiple cells that you want to split. Under Table Tools, on the Layout tab, in the Merge group, click Split Cells.
Highlight the 3 cells and right click --> format cells ---> alignment tab ---> check merge cells.
Enjoy!
152
For cells A1 and B1 use:
Range("A1:B1").Select
With Selection
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlBottom
.WrapText = False
.Orientation = 0
.AddIndent = False
.IndentLevel = 0
.ShrinkToFit = False
.ReadingOrder = xlContext
.MergeCells = False
End With
Selection.Merge
(The trick is the last line, the rest is generated using the Macro-recording features).
32
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
