excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · 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


 

Excel tip:

Editing a formula quickly

If 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

View all Excel hints and tips


Server loaded in 0.08 secs.