Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making a "Check Box" Larger
Hi,
I figured out how to insert a check box that automatically enters a tick mark in the box when I click on it. However, the box is pretty small. How do I change the size of the check box and the tick mark? RD |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making a "Check Box" Larger
As far as making the check box bigger -- you can't!
A kludge work-around is to increase the zoom. Increasing the zoom will make the check box bigger but it will also make *everything* bigger. What you could do is use a smaller text font on the entire sheet, like say font size 6, then if you increase the zoom the check box gets bigger and the size 6 font will also get bigger. If you experiment you can get the check box to the size you want and at the same time get the font size back to what it originally was (or very close). For example, if your default font size is 10, format the entire sheet to use a size 6 font. Then increase the zoom. The check box gets bigger and at the same time the size 6 font will get bigger to the point that it looks like the original size 10 font. -- Biff Microsoft Excel MVP "RJD" wrote in message ... Hi, I figured out how to insert a check box that automatically enters a tick mark in the box when I click on it. However, the box is pretty small. How do I change the size of the check box and the tick mark? RD |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
when a "check box" is checked, a "result" to be shown in another c | Excel Discussion (Misc queries) | |||
Check if cells contain the word "Thailand", return "TRUE" | Excel Worksheet Functions | |||
How can I check the "P" or "A" in the attendance sheet | Excel Worksheet Functions | |||
create links to check boxes marked "good" fair"and "bad" | Excel Worksheet Functions |