Record the Steps

8. Try it: Record the Macro

Select Row 21 (the one with the Sum).

Go to Home->Cells->Insert Sheet Row.

 

Use the Format Painter:

Format Same As Above.

 

Select Cell A22.

AutoFill to A23: Fill Weekdays.

 

Select Cells B22:E22.

AutoFill the values to B23:E23

 

Go to Developer ->Code.

Click on Stop Recording.

 

Keep going, please...

Exam 77-888: Microsoft Excel Expert 2010

4. Working with Macros and Forms

4.1. Create and manipulate macros.

Developer ->Code-> Stop Recording