J jerry chapman Jan 2, 2005 #1 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?
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?
D Don Guillett Jan 2, 2005 #2 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
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
