The desktop version of Microsoft Excel will soon support a nifty task automation feature previously available only to web application users, it has been revealed.
according to a new entry to the Microsoft 365 roadmap, an update for the Spreadsheet software will soon enable desktop users to program and run scripts that automate repetitive manual tasks.
“With this update, you can now create, edit, and run Office scripts in Excel for Windows using the code editor and All Scripts task pane,” explains Microsoft.
Microsoft Excel Automation
While the formula phobics among us have only just mastered the basics of Microsoft Excel, advanced users have long sought ways to optimize their workflows, especially when it comes to repetitive data entry tasks.
The goal of the upcoming update, which will be rolled out sometime in October, is to provide users willing to lay the groundwork with a platform to automate time-consuming manual tasks and improve their productivity.
The work of a single user can also help employees in an organization to automate workflows; once programmed, scripts can be freely shared between Microsoft 365 accounts.
“With Office Scripts in Excel you can automate your daily tasks. Within Excel you can record your actions with the Action Recorder. This creates a TypeScript language script that can be rerun at any time,” explains a Microsoft support document.
“You can also create and edit scripts with the Code Editor. Your scripts can then be shared across your organization so that your colleagues can automate their workflows as well.”
The arrival of Office scripts for the Excel desktop client represents the latest in a series of recent additions designed to help users increase their productivity.
For example, Microsoft recently revealed that it will soon be possible to start from within Excel documents Microsoft Teams calls. Instead of going out to work on a shared spreadsheet, collaborations can make real-time edits video conference.
Separately, the company announced a new, customizable version of the Excel Formula Bar, making it much easier to work with longer formulas, as well as a feature designed to help troubleshoot formula problems.