Automating Excel tasks is a lot easier with Office Scrips

News

Reading time icon 2 min. read

Calendar icon Published on

by Claudiu Andone 

published on

Share this article

Readers help support Windows Report. We may get a commission if you buy through our links. Tooltip Icon

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

Key notes

  • Microsoft Excel is the most important productivity tool for office workers all over the world.
  • Repetitive tasks in Excel are time-consuming but this problem is about to be solved with the new Office Scripts feature. 
  • Our Software page is populated with a plethora of articles about digital tools.
  • If you didn't get the latest digital stories you can find them in our News Hub. 

The Office suite is very popular, especially in the latest months when the work has moved abruptly from the office to our homes.

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

Now, the software giant has announced on the Microsoft 365 roadmap page that is rolling out Office Script for all Microsoft 365 Enterprise, Business, and EDU SKUs with access to the Office 365 desktop apps.

How is Office 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.

After you finished recording, you will just see a list of the steps you took to perform all the actions. Microsoft mentions that you won’t need any programming experience to edit the scripts but if you take the extra step to do so, a Code Editor will open, allowing you to modify the TypeScript code.

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 using automation but that’s not the only feature that was added to Excel lately. Check out our guide on how you can import data from a PDF in Excel.

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

[wl_navigator]

More about the topics: Excel, Office 365

Claudiu Andone

Claudiu Andone Shield

Windows Toubleshooting Expert

Oldtimer in the tech and science press, Claudiu is focused on whatever comes new from Microsoft. His abrupt interest in computers started when he saw the first Home Computer as a kid. However, his passion for Windows and everything related became obvious when he became a sys admin in a computer science high school. With 14 years of experience in writing about everything there is to know about science and technology, Claudiu also likes rock music, chilling in the garden, and Star Wars. May the force be with you, always!

User forum

0 messages