A young woman works at a tablet with her young child.

Record worksheet actions using Office Scripts in Excel

Feature deep dive
  • Share on Facebook
  • Share on Twitter
  • Share on LinkedIn

Happy new year, Office Insiders! I’m Nancy, a Product Manager on the Office Scripts team. My team and I are excited to help you start your year off right with the ability to record repetitive spreadsheet tasks and turn them into replayable Office Scripts in Excel for Windows and Excel for Mac.   

Record worksheet actions using Office Scripts

Up until now, you could create and modify automations using JavaScript and TypeScript using the Office Scripts Code Editor. With the Action Recorder, you can automate repetitive worksheet tasks without needing any programming experience.

How it works

 1. Open any existing workbook.

 2. Select Automate >Record Actions (Preview).

Automate tab

3. Record actions in your workbook.

4. When you’re done recording, click the Stop recording button in the Record Actions (Preview) task pane to save the recorded actions into a script that you can run at any time on any workbook.

Known issues

  • Not all actions are recordable at this time—we are continuing to add support to increase the number of recordable actions. We encourage you to continue trying to record actions useful to your workflow as that will help us prioritize the order in which we add support.

Requirements

To use Office Scripts in Excel for Windows or Excel for Mac, you must have the following. 

Availability

This feature is available to Office Insiders running:

  • Windows: Version 2212 (Build 15922.20000) or later
  • Mac: Version 16.68 (Build 22120101) or later

Don’t have it yet? It’s probably us, not you.

Features are released over some time to ensure things are working smoothly. We highlight features that you may not have because they’re slowly releasing to larger numbers of Insiders. Sometimes we remove elements to further improve them based on your feedback. Though this is rare, we also reserve the option to pull a feature entirely out of the product, even if you, as an Insider, have had the opportunity to try it.

Feedback 

Please select Help > Feedback to submit your feedback about this feature. Include the phrase “Office Scripts” in your feedback to ensure it reaches our team. We’re excited to hear from you!