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 · Urgent Priority · Version 2003

Loreen has attended:
Excel Intermediate course

Excel

How do I to insert a

Edited on Tue 22 Apr 2008, 12:37

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

Edited on Tue 22 Apr 2008, 12:36

RE: Excel

Sorry, somehow clicked the Submit button twice - Pete


 

Excel tip:

Change the Default Width of All Columns in Excel 2010

If you want to change the width of the columns in your Excel 2010 spreadsheet, making them either larger or smaller, here's how:

In the Cells group on the Home tab, click Format.

Hover over the section called Cell Size and a drop down list will appear, select Default Width from this list.

In the Standard Width dialog box, enter the size you want to set as the default width and click OK.

View all Excel hints and tips


Server loaded in 0.08 secs.