ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   form toolbar (https://www.excelbanter.com/excel-discussion-misc-queries/146922-form-toolbar.html)

Churley

form toolbar
 
I have many check boxes that I created from the form toolbar.
Is there an easy way to line them up and make them even?
No matter how hard I try, they don't stay even, and my spreadsheet looks
"messy".
Any suggestions would be greatly appreciated.

Thanks!

Mike H

form toolbar
 
Hi,

CTRL+Click each checkbox to select them all. Then

From the drawing toolbar click
Draw|Align or distribute
Align Left
Align Horizontal
or whatever alignment you want

Mike


"Churley" wrote:

I have many check boxes that I created from the form toolbar.
Is there an easy way to line them up and make them even?
No matter how hard I try, they don't stay even, and my spreadsheet looks
"messy".
Any suggestions would be greatly appreciated.

Thanks!


Churley

form toolbar
 
That works!
Thanks so much!

"Mike H" wrote:

Hi,

CTRL+Click each checkbox to select them all. Then

From the drawing toolbar click
Draw|Align or distribute
Align Left
Align Horizontal
or whatever alignment you want

Mike


"Churley" wrote:

I have many check boxes that I created from the form toolbar.
Is there an easy way to line them up and make them even?
No matter how hard I try, they don't stay even, and my spreadsheet looks
"messy".
Any suggestions would be greatly appreciated.

Thanks!



All times are GMT +1. The time now is 12:24 AM.

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