Tuesday, June 16, 2009

Excel: Additing Check Boxes to an Excel Cell

To add a check box or radio button to an Excel Spreadsheet, you must turn on the Developer's Tab and Ribbon. Click on the Office Button, select Excel Options, select Popular, select Show Developer tab in the Ribbon. This will give you access to the Developer Ribbon.
Once you have opened the Developer Ribbon, click on Insert, select the check box or radio button from the options.
To activate the box and button, save the spreadsheet as a Macro Enabled Spreadsheet. Click on the Office Button, select Save As, select Excel Macro Enabled.
Once saved the check boxes and radio buttons will be active.

3 comments:

  1. Some days ago I convert my excel file in other format and unfortunately it was damaged.In this situation friend said me about one nice tool-xlsx viewer.As he said it helped to him and has free status.Moreover program helped me too and it can farther recovery of corrupted worksheets in xltm, xlsx, xlt, xls, xlsm, xlam and xltx formats.

    ReplyDelete
  2. I was in situation,when I added one element into my MS Excel and after I reopened file and data was damaged.But I used the google and I found-repair Excel xls.Tool solved all problems in two minutes and made it without payment.Moreover tool demonstrated recover worksheets in Microsoft Excel format.

    ReplyDelete
  3. Yesterday evening I had unpleasant situation.Some of very important excel files were damaged no one knew how.But a friend advised me-Excel file repair software.And program solved this problem very easy and without payment.Moreover I saw how utility recovered contents and export of recovered data into a new document in Microsoft Excel format.

    ReplyDelete