excel
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

Excel

resolvedResolved · Urgent Priority · Version 2003

replyReply Tue 22 Apr 2008, 11:42Delegate Loreen said...

Loreen has attended:
Excel Intermediate course

Excel

How do I to insert a

For upcoming training course dates see: Pricing & availability

replyReply Tue 22 Apr 2008, 12:32 Edited on Tue 22 Apr 2008, 12:37Trainer Pete said...

RE: Excel

Hi Loreen, Thanks for the post, in answer to your question, inserting a tick box, follow these steps:
To create a check box follow these steps;
Open your worksheet
Go to View>Toolbars, and choose Forms.
Click the Check Box tool once, and click and drag somewhere near A1 in the worksheet to draw a check box.
When you release the mouse, click the Forms toolbar's Control Properties tool, or right-click the new check box, and choose Format Control.
(To take things a little further; Are you looking for a great way to get a 'Yes' or 'No' decision from an end user using Excel?)
Select the Text label and change it to text of your choice, let

replyReply Tue 22 Apr 2008, 12:32 Edited on Tue 22 Apr 2008, 12:36Trainer Pete said...

RE: Excel

Sorry, somehow clicked the Submit button twice - Pete

 

Please browse our web site to find out more about
learn excel in london and other Microsoft training courses.

Excel tip:

Adding cells, Rows & columns

place your cursor on a cell, row number or column letter and use CTRL + SHIFT + + or CTRL + + depending on which + you prefer to use.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard