Group items tagged

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.

How it works* * Open PDF Form Filler, then open your PDF. * Click all the fields and checkboxes that need to be filled in to highlight them. * When all the fields and checkboxes are highlighted, switch to 'Fill Form' mode. * Enter text in the text fields. Check the boxes. * Press 'Print' to print your hardcopy. * Press 'Save' and the form is saved as a new PDF.