Copy the Control

This little Combo Box works, now. Here are the steps to copy and paste the control to the other Cells in the Time Sheet.

 

5. Try it: Copy and Paste the Control

Right-click the Control to select it. You should see Handles in each corner.

Go to Home ->Copy.

Click on Cell A3.

Go to Home-> Paste.

 

Paste the Control in Cells A4 through A12.

 

Do This, Too: Save Your Work

Go to File->Save.

Type the File Name: MyName Timesheet

Click on Save.

 

Very good.

Exam 77-888: Microsoft Excel Expert 2010

4. Working with Macros and Forms

4.2. Insert and manipulate form controls

Home ->Copy