Vertical Alignment Center by Default?

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


  • 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

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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!