Record a macro

1. On the View tab, select Macros and choose   Record Macro. 

2. Give the macro a name, and assign a shortcut key if you want. 

3. Select OK to start recording and perform the actions you want to automate.

4. To end recording, on the View tab, select Macros and then choose   Stop Recording.

Tip: To play it back, select Macros, choose the macro, and then select Run, or use the shortcut key.

1. On the View tab and select   Record Macro. 

2. Give the macro a name, and assign a shortcut key if you want. 

3. Select OK to start recording and perform the actions you want to automate.

4. On the View tab, select   Stop Recording.

Tip: To play it back, select View Macros, choose the macro, and then select Run, or use the shortcut key.

1. On the Automate tab, select  Record Actions.

2. Perform the actions you want to automate.

3. On the Record Actions pane, select   Stop.

To get started, see Introduction to Office Scripts in Excel.

Tip: To play or change the script, select   Run or   Edit. in the Record Actions pane.