Up until now in Excel Desktop for Microsoft 365 Apps, 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.
- Open any existing workbook.
- Select Automate >Record Actions (Preview).
- Record actions in your workbook.
- 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.
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.
(Note: This feature requires Microsoft 365 E3/E5 or A3/A5)
Read more about this new feature in Excel here:
- Record worksheet actions using Office Scripts in Excel
https://insider.microsoft365.com/en-us/blog/record-worksheet-actions-using-office-scripts-in-excel
kurtsh
Kurt Shintaku's Blog 