ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Check box gets weird size when cell height grows (https://www.excelbanter.com/excel-discussion-misc-queries/180742-check-box-gets-weird-size-when-cell-height-grows.html)

Rene

Check box gets weird size when cell height grows
 
How can I get a check box to show in multiple cells going down a column?
I inserted a simple check box under a column named "Confirmed" through the
Control Toolbox, for simple visual confirmation. When I copy that check box
down using autofill it just gets out of alignment and, if ther cell height is
more than the original one, it gets very long, distorted. I tried help with
the properties, but the only one that I can get help on is the Accelerator.
--
Rene - Do appreciate your help

Jim Thomlinson

Check box gets weird size when cell height grows
 
Right click the Check Box while in design mode and select Format Controls -
Properties (tab) and change the options accordingly...
--
HTH...

Jim Thomlinson


"Rene" wrote:

How can I get a check box to show in multiple cells going down a column?
I inserted a simple check box under a column named "Confirmed" through the
Control Toolbox, for simple visual confirmation. When I copy that check box
down using autofill it just gets out of alignment and, if ther cell height is
more than the original one, it gets very long, distorted. I tried help with
the properties, but the only one that I can get help on is the Accelerator.
--
Rene - Do appreciate your help



All times are GMT +1. The time now is 09:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com