4 Replies Latest reply: Mar 30, 2012 8:07 AM by Wayne Contello
Canam Carlo Level 1 Level 1 (0 points)

Hello all,

I am trying to do my Income Tax Returns (Belize, Central America). The Income Tax Department here has its Tax Return form in Excel mode, but I prefer Numbers to Excel. I would like to change a box they have on the form into a check box, so that in the form, while preparing it, I can check it, rather than do so after I print. Is there some way of doing this?

 

I would be appreciative of timely answers, as the return form is for submission today.


MacBook Pro, Mac OS X (10.7.3), 2.4 i5, 4Gb DDR3, 500Gb
  • Wayne Contello Level 6 Level 6 (14,470 points)

    highlight the cell you want to be a checkbox:

    Screen Shot 2012-03-30 at 9.45.23 AM.png

    Then click the checkbox tool in the toolbar:

    Screen Shot 2012-03-30 at 9.45.29 AM.png

     

    Then check or uncheck the box as needed:

     

    This post does not constitute a recommendation to check or uncheck the check box for purposes of tax preparation 

  • Canam Carlo Level 1 Level 1 (0 points)

    I wish it did constitute a recommendation to check or uncheck!! Thanks Wayne. I actually just found it when notification of your answer came in. I was hoping to have the checkbox as an overlay, rather than in a dedicated cell. I realize that I have to have it in a dedicated cell, so I am now in the process of revising the form. I intend to save the form as a template.

     

    Unlike the USA's IRS, our stuff here in Belize is quite simple. I am surprised at how difficult it is to do tax returns in the US. No wonder things like Turbo Tax and places like H&R Block can actually make a profit.

  • Canam Carlo Level 1 Level 1 (0 points)

    Is there a way to insert text into the background of the cell with the checkbox?

  • Wayne Contello Level 6 Level 6 (14,470 points)

    No.  You could try putting an image (of the text) as the background but that seems like a pain.  You could make the checkbox column narrow and use the previous colmn for the text OR add a text box from the "Shapes" menu in the tool bar