How to align check boxes on an Excel sheet?
 

I am creating an Excel form with check boxes. I cannot align the boxes in
the column. I tried Snap to Grid and Align and Distribute (which remained
gray) in the Draw toolbar. The boxes didn't budge.
Any suggestions?
Thanks,
CC

Hi!

Are these checkboxes on a worksheet or on a user form?

If they're on a worksheet get the first one aligned the
way you want it and then just copy and paste to other
cells as needed. The alignment/placement of the first
checkbox will be copied to the other cells making exact
alignment a snap.

Biff

-----Original Message-----
I am creating an Excel form with check boxes. I cannot
align the boxes in
the column. I tried Snap to Grid and Align and
Distribute (which remained
gray) in the Draw toolbar. The boxes didn't budge.
Any suggestions?
Thanks,
CC
.

Thanks Biff! That looks 100% better.
CC

"Biff" wrote:

Hi!

Are these checkboxes on a worksheet or on a user form?

If they're on a worksheet get the first one aligned the
way you want it and then just copy and paste to other
cells as needed. The alignment/placement of the first
checkbox will be copied to the other cells making exact
alignment a snap.

Biff

-----Original Message-----
I am creating an Excel form with check boxes. I cannot
align the boxes in
the column. I tried Snap to Grid and Align and
Distribute (which remained
gray) in the Draw toolbar. The boxes didn't budge.
Any suggestions?
Thanks,
CC
.