Automating Excel tasks is a lot easier with Office Scrips

2 min. read

Published onAugust 14, 2020

published onAugust 14, 2020

Share this article

Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more

Key notes

TheOffice suiteis very popular, especially in the latest months when the work has moved abruptly from theofficeto our homes.

At the start of this year, Microsoft released Office Scripts, a very useful automation feature forExcel, but only for public preview.

Now, the software giant has announced on theMicrosoft 365 roadmap pagethat is rolling out Office Script forall Microsoft 365 Enterprise, Business, and EDU SKUs with access to the Office 365 desktop apps.

How isOffice Scripts helping you get rid of repetitive tasks?

Office Scripts is working as a macro. It allows you to record your actions, and replay them over and over again.

The scripts can be edited and they are stored in the cloud. You will be able to record actions like typing text or numbers, clicking cells, commands, menus, formatting cells, rows or columns, and many other actions.

The only problem with the new Office Scripts is that once you start recording, it will also memorize any possible mistakes you make. So you have to make sure you record the script as smoothly as possible.

The new feature can save you hours of work usingautomationbut that’s not the only feature that was added toExcellately. Check out our guide onhow you can import data from a PDF in Excel.

What do you think about the new Office Scripts feature inExcel? Drop us a line in the Comments section.

[wl_navigator]

With KB5043178 to Release Preview Channel, Microsoft advises Windows 11 users to plug in when the battery is low#

Copilot in Outlook will generate personalized themes for you to customize the app#

Microsoft will raise the price of its 365 Suite to include AI capabilities#

Death Stranding Director’s Cut is now Xbox X|S at a huge discount#

Outlook will let users create custom account icons so they can tell their accounts apart easier#

Automating Excel tasks is a lot easier with Office Scrips#

How isOffice Scripts helping you get rid of repetitive tasks?#

With KB5043178 to Release Preview Channel, Microsoft advises Windows 11 users to plug in when the battery is low

Copilot in Outlook will generate personalized themes for you to customize the app

Microsoft will raise the price of its 365 Suite to include AI capabilities

Death Stranding Director’s Cut is now Xbox X|S at a huge discount

Outlook will let users create custom account icons so they can tell their accounts apart easier

Automating Excel tasks is a lot easier with Office Scrips

How isOffice Scripts helping you get rid of repetitive tasks?