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.
Daily posts of Excel tips…and other stuff
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.
THANKS!!!! This has made my excel sheets soooooo much prettier/neater!
Stephen
Note that this also works for pictures, in a slightly different way.
Holy hell. I wish I would have known about this years ago.