Kylie has attended:
Excel Intermediate course
Excel
Hello,
I would like to add some tick boxes next to a spreadsheet on Excel. By this I mean when you click on the box it will automatically add a tick.
What we are doing is creating a wine list through excel where our guests are able to select their wine and email the form back to us.
We previously had an spreadsheet with tick boxes on them but can not find out how they did this.
The boxes look like a indent in the spreadsheet.
Thanks for your help.
RE: Excel
Hello Kylie
Thank you for your question.
You can add tick boxes to a spreadsheet using the Control Toolbox (View - Toolbars - Control Toolbox).
Click on the Check box tool on this toolbar, and then bring your cursor onto the spreadsheet and drag diagonally. This will allow you to draw a check box on the spreadsheet.
You can copy and paste the check box to create multiple check boxes.
When you have finished drawing and positioning the check boxes, then click the Exit Design Mode button on the Control Toolbox so the check boxes can be used.
I hope this helps.
Amanda
