ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to set up a column with check boxes (https://www.excelbanter.com/excel-discussion-misc-queries/168410-how-set-up-column-check-boxes.html)

lbierer

How to set up a column with check boxes
 
I am trying to set up a spreadsheet with a column named completed. I want to
be able to just click on a box and it shows a check mark. How do you do this?

Kevin B

How to set up a column with check boxes
 
Click VIEW on the menu and select TOOLBARS. Click the FORMS to display the
forms toolbar.

Click the check box control and then click in the worksheet to place the
check box in the workbook. Copy and paste as needed.

When finished, click the Design Mode button (the one w/the triangle, ruler &
pencil) to exit design mode.


--
Kevin Backmann


"lbierer" wrote:

I am trying to set up a spreadsheet with a column named completed. I want to
be able to just click on a box and it shows a check mark. How do you do this?



All times are GMT +1. The time now is 08:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com