graphic2
graphic1

Exam 77-420 Microsoft Excel 2013
1. Create and Manage Worksheets and Workbooks
1.4 Customize Options and Views for Worksheets and Workbooks: Record Simple Macros

Record a Macro

The Macro Recorder follows your actions as you go through a process. Let's record a simple Macro that Finds specific text, replaces the text and Formats the replacement text a different color.

 

What are the steps?

Find the Text.

Use Replace to substitute different text.
Format the color of the new text.
Then Replace All.

 

1. Try it: Record a Macro

Go to Developer ->Code.

Click on Record Macro.

 

What Do You See? You will be prompted to type a name for your Macro.

Type: UpdateProductsA

(No spaces, please)

 

What Else Do You See? Your new Macro will be stored in This Workbook. Enter the description shown on this page if you wish.

Click OK.

Keep going...

Developer ->Code-> Record Macro