Value spans three columns

[jerry chapman]

How can I put a value in row 2 that spans columns j, k and l, and have it
centered horizontally in those three columns?

 

[Don Guillett]

Use format>alignment>center across selection.

Suggest adding a custom icon to your toolbar by right click
toolbar>customize>

Sub CenterAcross()
Selection.HorizontalAlignment = xlCenterAcrossSelection
End Sub