Add checkboxes to an Excel spreadsheet

July 08, 2013

Tgood37 asked the Answer Line forum how to add checkboxes to Excel spreadsheets, and how to make sure that checking a box will have an effect. 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. To read this article in full or to leave a comment, please click here

Link: http://www.pcworld.com/article/2042382/add-checkboxes-to-an-excel-spreadsheet.html#tk.rss_howto