Record the Steps The Macro Recorder is ready, although you will not see a little media player or device.   Go through the process of selecting a cell and adding a new row. The Macro Recorder will follow your actions.   2. Try it: Add a Row Go to the Legs spreadsheet. Select Row 21. Go to Home->Cells->Insert Sheet Row.   Use the Format Painter: Format Same As Above.   Select Cell A21. Use the AutoFill: Fill Weekdays.   Keep going... Memo to Self: The Macro Recorder tracks when the steps are right as well as when you make a mistake. You may wish to practice the steps a couple of times before you start the Macro Recorder. Exam 77-888: Microsoft Excel Expert 2010 4. Working with Macros and Forms 4.1. Create and manipulate macros: Record a Macro Home->Cells->Insert Sheet Row