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.
Certain comments are subject to moderation and may not appear immediately. You can use HTML tags in your comment. If you include a greater-than or less-than sign or anything else that could be interpreted as HTML, your comment won't look nice. You need to escape those characters. To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].
Stephen Wortley:
THANKS!!!! This has made my excel sheets soooooo much prettier/neater!
Stephen
12 August 2004, 11:20 amcharlie:
Note that this also works for pictures, in a slightly different way.
13 August 2004, 4:04 am