Excel Unable To Merge Cells

Hi Bwhite130 

Try the following shortcuts to merge the cells in your workbook

Excel Shortcuts for Merge the Cells in Windows

• Merge Cells: ALT H+M+M
• Merge & Center: ALT H+M+C
• Merge Across: ALT H+M+A
• Unmerge Cells: ALT H+M+U

Also for a detailed description of the Merge and Unmerge cells option in excel, please refer the below link:

https://support.microsoft.com/en-us/office/merge-and-unmerge-cells-5cbd15d5-9375-4540-907f-c673a93fcedf

Thanks,

Suyash Thomson

Bwhite130 

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.

NikolinoDE

I know I don't know anything (Socrates)

Was the answer useful? Mark them as helpful!

This will help all forum participants.