graphic2
graphic1

Exam 77-428 Microsoft Excel 2013 EXPERT
2. Apply Custom Formats and Layouts
2.3 Apply Custom Styles and Templates: Create Form Fields

pic1

Copy the Control

This little Combo Box works, now. This is a Control, so you cannot AutoFill the Combo Box. 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 ->Clipboard->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.

Home ->Clipboard->Copy