Controls: Snap To Grid

When placing ActiveX or Forms controls on a worksheet, aligning them can be a chore. Hold down the Alt key while you’re moving the controls and they will align to the cell borders, making the job much easier.

3 Comments

  1. Stephen Wortley says:

    THANKS!!!! This has made my excel sheets soooooo much prettier/neater!

    Stephen

  2. charlie says:

    Note that this also works for pictures, in a slightly different way.

  3. Brett says:

    Holy hell. I wish I would have known about this years ago.

Leave a Reply