To make workplaces more efficient and productive, Microsoft is working on a new feature that will let Excel users save their Office Scripts on a SharePoint site. The feature will be available in July.
Microsoft announced a new Office Scripts feature for Excel on the web.
The feature lets you create automated scripts that make it easy to repeat steps within spreadsheets.
You can use Excel s Action Recorder to record your steps to create scripts.
If you regularly work with Excel spreadsheets, you probably have to repeat the same steps on a routine basis. For example, you may need to import data, delete some columns, and reformat parts of the spreadsheet every day. To speed this process up and to reduce repetitive tasks, Microsoft has a new feature called Office Scripts.
Office Scripts is an automation feature available for Excel on the web. Microsoft announced its general availability today and outlines the feature in a Tech Community post.