Group items tagged checkbox - Diigo Community

V5 : the place of the "private " checkbox... - 10 views

started by Tyme 2.0 on 05 Jul 10 3 follow-ups, last by Tyme 2.0 on 06 Jul 10

1More

Add checkboxes to an Excel spreadsheet - 1 views

techvedic.livejournal.com/39196.html add checkbox to excel adding a in for on create

shared by tech vedic on 12 Jul 13 - No Cached

tech vedic on 12 Jul 13

If you're setting up a worksheet only for yourself, you can simply leave an empty cell for this purpose. To check it, just type in an x or any other character. Then use a formula with the =isblank() function to make the contents of that cell affect the rest of the spreadsheet. But you might want something more mouse-friendly--especially if you're designing a spreadsheet for other people. I've tested the technique below on Excel 2007, 2010, and 2013. I'm not sure about earlier versions. You can insert checkboxes on Excel's Developer tab. Unfortunately, that tab is hidden by default. To make it visible in Excel 2010 or 2013, click the File tab and select Options. ClickCustomize Ribbon. You'll see two lists. Make sure that the one on the right is titled Main Tabs. Check Developer.

<div class="cArrow"> </div><div class="cContentInner">If you're setting up a worksheet only for yourself, you can simply leave an empty cell for this purpose. To check it, just type in an x or any other character. Then use a formula with the =isblank() function to make the contents of that cell affect the rest of the spreadsheet. But you might want something more mouse-friendly--especially if you're designing a spreadsheet for other people. I've tested the technique below on Excel 2007, 2010, and 2013. I'm not sure about earlier versions. You can insert checkboxes on Excel's Developer tab. Unfortunately, that tab is hidden by default. To make it visible in Excel 2010 or 2013, click the File tab and select Options. ClickCustomize Ribbon. You'll see two lists. Make sure that the one on the right is titled Main Tabs. Check Developer.</div>

...

Cancel