98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Excel
Resolved · High Priority · Version 2003
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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Editing a formula quicklyIf you want to edit a fomrula or text quickly witin a cell instead of the formula bar, you can click either double click in the cell or press the F2 key |