Vertical Alignment Center by Default?

tdang · Oct 5th 2004

Is there a way to make the vertical alignment center by default? This would be especially useful when using the merge and center shortcut.

Thanks!

lasw10 · Oct 5th 2004

you can do this in VBA if you wish to... (don't know if you can force it via options etc... don't think so)

in VBA (Alt + F11 is shortcut) - in ThisWorkbook add

Code

Private Sub Workbook_Open()
Application.Cells.VerticalAlignment = xlCenter
End Sub

Participate now!