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

excel

ResolvedVersion 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:

Adding multiple rows in an Excel 2010 Worksheet

If you want to add more than one row to an Excel Worksheet, drag select the number or rows you want added to the spreadsheet.

Then right click on these selected rows, choose Insert from the menu, and the new rows will be added above the rows you first selected.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.