In the Microsoft Visual Basic for Applications window, please click Insert > Module. In the worksheet, you need to auto-center all checkboxes, press the Alt + F11 keys to open the Microsoft Visual Basic for Applications window.Ģ. To automatically center all checkboxes in cells in a current worksheet, please do as follows.ġ. Method in this article can help you.Īuto-center checkbox in cell with VBA code Actually, you can move all check boxes to cell center to keep them in order neatly. While inserting check boxes in cells in Excel, you might notice that it is hard to arrange all checkboxes orderly as the left screenshot shown. How to auto-center checkbox in cell in Excel?